------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\Yanan and Ben\Desktop\NHPI-exercise Replication Package\20250822-brfss2015-dataprep.log
  log type:  text
 opened on:  25 Aug 2025, 04:37:28
r; t=0.01 4:37:28

. version 15.1
r; t=0.00 4:37:28

. clear   all
r; t=0.02 4:37:28

. macro   drop _all
r; t=0.00 4:37:28

. set     linesize 80
r; t=0.00 4:37:28

. set     scheme plottig
r; t=0.00 4:37:28

. set             more off
r; t=0.00 4:37:28

. set             varabbrev off
r; t=0.00 4:37:28

. set     rmsg on
r; t=0.00 4:37:28

. 
. // #0. Document this do-file
.         local today : di %tdCY/N/D daily("$S_DATE", "DMY")
r; t=0.01 4:37:28

.         tokenize `today',parse("/")
r; t=0.00 4:37:28

.         local year `1'
r; t=0.00 4:37:28

.         local month `3'
r; t=0.00 4:37:28

.         local day `5'
r; t=0.00 4:37:28

. 
.         local who "Ben Cheung"
r; t=0.00 4:37:28

.         local pgm "20250822-brfss2015-dataprep"
r; t=0.00 4:37:28

.         local date "`year'-`month'-`day'"
r; t=0.00 4:37:28

.         local tag "`pgm'.do by `who' on `date'"
r; t=0.00 4:37:28

.         display "The tag is: `tag'"
The tag is: 20250822-brfss2015-dataprep.do by Ben Cheung on 2025-08-25
r; t=0.00 4:37:28

. 
. 
.         local today : di %tdCYND daily("$S_DATE", "DMY")
r; t=0.00 4:37:28

. 
. 
.         *Check for installed packages
.         capture which scheme-plottig.scheme
r; t=0.00 4:37:28

.         if _rc!=0 ssc install blidschemes
r; t=0.00 4:37:28

. 
.         capture which confirmdir
r; t=0.00 4:37:28

.         if _rc!=0 ssc install confirmdir
r; t=0.00 4:37:28

. 
.         capture which estout
r; t=0.01 4:37:28

.         if _rc!=0 ssc install estout
r; t=0.00 4:37:28

. 
.         capture which sum2docx
r; t=0.00 4:37:28

.         if _rc!=0 ssc install sum2docx
r; t=0.00 4:37:28

. 
.         capture which tab2xl
r; t=0.01 4:37:28

.         if _rc!=0 net install http://www.stata.com/users/kcrow/tab2xl, replace
r; t=0.00 4:37:28

. 
.         set scheme plottig
r; t=0.00 4:37:28

. 
. 
. local folder "Original data"
r; t=0.00 4:37:28

. confirmdir "`folder'"
r; t=0.00 4:37:28

. if `r(confirmdir)'==170 {
.         mkdir "`folder'"
r; t=0.00 4:37:28
. }
r; t=0.00 4:37:28

. 
. 
. 
. local folder "Data Ready for Analysis"
r; t=0.00 4:37:28

. confirmdir "`folder'"
r; t=0.00 4:37:28

. if `r(confirmdir)'==170 {
.         mkdir "`folder'"
r; t=0.00 4:37:28
. }
r; t=0.00 4:37:28

. 
. 
. 
. 
. *Define custom program to show command in loop
. program define pe
  1.         version 15.1
  2.         if `"`0'"' != "" {
  3.                 display("")
  4.                 display as input `". `0'"'
  5.                 `0'
  6.                 display("")
  7.         }
  8. end
r; t=0.00 4:37:28

. 
. 
. 
. 
. 
. // #1. Data management
. import sasxport "Original Data/LLCP2015.XPT",clear
r; t=46.20 4:38:14

. 
. 
. 
. 
. // #2. Data management
. *Survey setup in Stata: https://www.cdc.gov/copd/pdfs/BRFSS_COPD_Syntax.pdf
. 
. *calculated variables for race vary across years:
. *_racegr (1993-2000): 1=Non-hispanic white, 2=Non-hispanic black, 3=Hispanic, 
> 4=Other, 9=missing (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00
> .pdf)
. *_racegr2 (2001-2012): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispa
> nic other, 4=Non-hispanic multiracial, 5=Hispanic, 9=missing (https://www.cdc.
> gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *_racegr3 (2013-2019): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispa
> nic other, 4=Non-hispanic multiracial, 5=Hispanic, 9=missing (https://www.cdc.
> gov/brfss/annual_data/2019/pdf/codebook19_llcp-v2-508.HTML)
. 
. 
. *race (1993-2000): 1=Non-hispanic white, 2=Non-hispanic black, 3=Hispanic-whit
> e, 4=Hispanic-black, 5=Other hispanic, 6=Non-hispanic asian/Pacific Islander, 
> 7=Non-hispanic Native American, 8=Non-hispanic other, 9=missing (https://www.c
> dc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *race2 (2001-2012): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispanic
>  asian, 4=Non-hispanic Native Hawaiian/Pacific Islander, 5=Non-hispanic Native
>  American, 6=Non-hispanic other, 7=Non-hispanic multiracial, 8=Hispanic, 9=mis
> sing (https://www.cdc.gov/brfss/annual_data/2001/pdf/riskfactor_01.pdf)
. *_race (2013-2019): 1=Non-hispanic white, 2=Non-hispanic black, 3=Non-hispanic
>  Native American, 4=Non-hispanic asian, 5=Non-hispanic Native Hawaiian/Pacific
>  Islander, 6=Non-hispanic other, 7=Non-hispanic multiracial, 8=Hispanic, 9=mis
> sing (https://www.cdc.gov/brfss/annual_data/2013/pdf/2013_calculated_variables
> _version15.pdf)
. 
. 
. *Starting from 2001, Hispanic was no longer further partitioned into different
>  racial groups (i.e., Hispanic-black, Hispanic-white...).
. *Since I need to construct Hispanic non-black and Hispanic Black as two racial
> /ethnic groups in the data, I need to obtain the original racial and ethnic gr
> oups variables to compute these two groups myself.
. *_prace (2001-2012): 1=White, 2=Black/African American, 3=Asian, 4=Native Hawa
> iian/Pacific Islander, 5=American Indian/Alaskan Native, 6=Other, 7=No preferr
> ed race, 8=Multiracial but no preferred race, 77=Don't know/not sure, 99=Refus
> ed (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *_prace1 (2013-2019): 1=White, 2=Black/African American, 3=American Indian/Ala
> skan Native, 4=Asian, 5=Native Hawaiian/Pacific Islander, 6=Other, 7=No prefer
> red race, 8=Multiracial but no preferred race, 77=Don't know/not sure, 99=Refu
> sed (https://www.cdc.gov/brfss/annual_data/2013/pdf/CODEBOOK13_LLCP.pdf)
. *hispanc2 (2001-2012): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused (https://
> www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *_hispanc (2013-2019): 1=Hispanic/Latino/Spanish origin, 2=Not of Hispanic/Lat
> ino/Spanish origin, 9=Don't know/refused (https://www.cdc.gov/brfss/annual_dat
> a/2013/pdf/CODEBOOK13_LLCP.pdf)
. 
. 
. 
. *survey weight:
. *_finalwt (1993-2010): 9999999999=unknown (https://www.cdc.gov/brfss/annual_da
> ta/1993/pdf/layout93.pdf)
. *_llcpwt (2011-2019): (https://www.cdc.gov/brfss/annual_data/2011/pdf/BRFSS201
> 1_Analysis.pdf)
. 
. 
. *strata:
. *_ststr (1993-2019)
. 
. *PSU:
. *_psu (1993-2019)
. 
. *Questionnaire version:
. *_qstver (1997-2001): 1=Version 1, 2=Version 2, BLANK=Not applicable (https://
> www.cdc.gov/brfss/annual_data/1997/files/CODEBK97.TXT)
. *_qstver (2002): No documentation and the categories are weird (https://www.cd
> c.gov/brfss/annual_data/2002/pdf/codebook_02.pdf)
. *qstver (2003): 1=Version 1, 2=Version 2, BLANK=Missing (https://www.cdc.gov/b
> rfss/annual_data/2003/pdf/Codebook_03.pdf)
. *qstver (2004-2007): 0=Only version, 1=Version 1, 2=Version 2, BLANK=Missing (
> https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *qstver (2009): 0=Only version, 1=Version 1, 2=Version 2, 3=Version 3, BLANK=M
> issing (https://www.cdc.gov/brfss/annual_data/2008/pdf/codebook08.pdf)
. *qstver (2010): 10=Only version, 11=Version 1, 12=Version 2, 13=Version 3 (htt
> ps://www.cdc.gov/brfss/annual_data/2010/pdf/codebook_10.pdf)
. *qstver (2011): 10=Only version, 11=Version 1, 12=Version 2, 13=Version 3, 20=
> Only Version Cell Phone (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBO
> OK11_LLCP.pdf)
. *qstver (2012-2019): 10=Only version, 11=Version 1, 12=Version 2, 13=Version 3
> , 20=Only Version Cell Phone, 21=Version 1 Cell Phone, 22=Version 2 Cell Phone
> , 23=Version 3 Cell Phone (https://www.cdc.gov/brfss/annual_data/2012/pdf/CODE
> BOOK12_LLCP.pdf)
. 
. 
. 
. *age:
. *age (1993-2012): 07=Don't know/not sure, 09=Refused
. *_age80 (2013-2019): imputed age from 18 to 80
. 
. 
. *employment status:
. *employ (1993-2012):1=Employed, 2=Self-employed, 3=Out of work for more than 1
>  year, 4=Out of work for less than 1 year, 5=Homemaker, 6=Student, 7=Retired, 
> 8=Unable to work, 9=Refused (https://www.cdc.gov/brfss/annual_data/1993/pdf/la
> yout93.pdf)
. *employ1 (2013-2019):1=Employed, 2=Self-employed, 3=Out of work for 1 year or 
> more, 4=Out of work for less than 1 year, 5=Homemaker, 6=Student, 7=Retired, 8
> =Unable to work, 9=Refused (https://www.cdc.gov/brfss/annual_data/2013/pdf/COD
> EBOOK13_LLCP.pdf)
. 
. *sex:
. *sex (1993-2015): 1=Male, 2=Female, 9=Refused (https://www.cdc.gov/brfss/annua
> l_data/1993/pdf/layout93.pdf)
. *sex1 (2018): 1=Male, 2=Female, 7=Don't know/not sure, 9=Refused (https://www.
> cdc.gov/brfss/annual_data/2018/pdf/codebook18_llcp-v2-508.pdf)
. *sexvar (2019): 1=Male, 2=Female (https://www.cdc.gov/brfss/annual_data/2019/p
> df/codebook19_llcp-v2-508.HTML)
. 
. 
. *SRH:
. *genhlth: 1=Excellent, 2=Very good, 3=Good, 4=Fair, 5=Poor, 7=Don't know/not s
> ure, 9=Refused (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *In 1996, Tennessee (FIPS: 47) didn't ask the SRH question.
. 
. *Number of days in last month with not good physical health:
. *physhlth: 1, 2, 3... 30 days, 77=Don't know/not sure, 88=None, 99=Refused (ht
> tps://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. 
. *Number of days in last month with not good mental health:
. *menthlth: 1, 2, 3... 30 days, 77=Don't know/not sure, 88=None, 99=Refused (ht
> tps://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. 
. *Number of days in last month keeping R from usual activities due to poor phys
> ical/mental health:
. *poorhlth: 1, 2, 3... 30 days, 77=Don't know/not sure, 88=None, 99=Refused (ht
> tps://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. 
. 
. *Asthma (ever told by doctor you have asthma):
. *asthma (1999-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=skip
> ped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *asthma2 (2001-2010): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=ski
> pped or missing (https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pd
> f)
. *asthma3 (2011-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused (https://w
> ww.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. 
. *Cholesterol (ever told by doctor you have high blood cholesterol):
. *toldhi (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused (https://ww
> w.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *toldhi2 (2001-2005, 2007, 2009, 2011, 2013, 2015, 2015, 2019): 1=Yes, 2=No, 7
> =Don't know/Not sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/2001/pd
> f/codebook_01.pdf)
. 
. *Heart attack (ever told by doctor you have heart attack) (asked by all states
>  since 2005):
. *cvdinfar (1996-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *cvdinfr2 (2001-2004): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *cvdinfr3 (2005-2006): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2006/pdf/codebook_06.pdf)
. *cvdinfr4 (2007-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2012/pdf/CODEBOOK12_LLCP.pdf)
. 
. 
. *Coronary heart disease (ever told by doctor you have coronary heart disease) 
> (asked by all states since 2005):
. *cvdcorhd (1996-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *cvdcrhd2 (2001-2004): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *cvdcrhd3 (2005-2006): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2006/pdf/codebook_06.pdf)
. *cvdcrhd4 (2007-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2012/pdf/CODEBOOK12_LLCP.pdf)
. 
. 
. *Stroke (ever told by doctor you have stroke) (asked by all states since 2005)
> :
. *cvdstrok (1996-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *cvdstrk2 (2001-2004): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *cvdstrk3 (2005-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2006/pdf/codebook_06.pdf)
. 
. 
. *Diabetes (ever told by doctor you have diabetes):
. *diabetes (1993): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused (https://www.c
> dc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *diabetes (1994-2003): 1=Yes, 2=Yes but during pregnancy, 3=No, 7=Don't know/N
> ot sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00
> .pdf)
. *diabete2 (2004-2010): 1=Yes, 2=Yes but during pregnancy, 3=No, 4=borderline d
> iabetes, 7=Don't know/Not sure, 9=Refused, BLANK=skipped or missing (https://w
> ww.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *diabete3 (2011-2018): 1=Yes, 2=Yes but during pregnancy, 3=No, 4=borderline d
> iabetes, 7=Don't know/Not sure, 9=Refused, BLANK=skipped or missing (https://w
> ww.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *diabete4 (2019): 1=Yes, 2=Yes but during pregnancy, 3=No, 4=borderline diabet
> es but during pregnancy, 7=Don't know/Not sure, 9=Refused, BLANK=skipped or mi
> ssing (https://www.cdc.gov/brfss/annual_data/2019/pdf/codebook19_llcp-v2-508.H
> TML)
. 
. 
. *High blood pressure (ever told by doctor you have high blood pressure):
. *bphigh (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=skip
> ped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *bphigh2 (2001): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=skipped 
> (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebook_01.pdf)
. *bphigh3 (2002-2004): 1=Yes, 2=Yes but during pregnancy, 3=No, 7=Don't know/No
> t sure, BLANK=skipped (https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook
> _04.pdf)
. *bphigh4 (2005, 2007, 2009, 2011, 2013, 2015, 2015, 2019): 1=Yes, 2=Yes but du
> ring pregnancy, 3=No, 4=borderline high, 7=Don't know/Not sure, 9=Refused, BLA
> NK=skipped (https://www.cdc.gov/brfss/annual_data/2015/pdf/codebook17_llcp-v2-
> 508.pdf)
. 
. 
. *last routine checkup:
. *checkup (1993-2002, 2005-2006): 1=1 to 12 months ago, 2=1 to 2 years ago, 3=2
>  to 5 years ago, 4=5 or more years ago, 7=Don't know/not sure, 8=Never, 9=Refu
> sed (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *checkup1 (2007-2019): 1=less than 12 months ago, 2=1 to less than 2 years ago
> , 3=2 to less than 5 years ago, 4=5 or more years ago, 7=Don't know/not sure, 
> 8=Never, 9=Refused (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_
> LLCP.pdf)
. 
. 
. *******************Alcohol drinking questions start*******************
. *Any alcohol drinking in past 30 days:
. *drinkany (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *(no such question in 2001-2004, since it was combined with alcdays and alcday
> 3. There were calculated variables based on alcdays and alcday3)
. *drnkany4 (2005-2010): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2005/pdf/Codebook_05.pdf)
. *no such question in 2010-2019, since it was combined with alcdays and alcday3
> . There were calculated variables based on alcday5)
. 
. 
. *Days of alcohol drinking in the last 30 days (asked by all states since 2001)
> :
. *alcohol (1993-2000): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-231= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 999=Refused, BLANK=skipped (https://www.cdc.gov/brfss/annual_d
> ata/2000/pdf/codebook_00.pdf)
. *alcdays (2001): 101-107=Number of days per week (1 indicates weekly number), 
> 201-230= Number of days per month (2 indicates monthly number), 777=Don't know
> /Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/brfss
> /annual_data/2001/pdf/codebook_01.pdf)
. *alcday3 (2002-2004): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-230= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/
> brfss/annual_data/2002/pdf/codebook_02.pdf)
. *alcday4 (2005-2010): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-230= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/
> brfss/annual_data/2010/pdf/codebook_10.pdf)
. *alcday5 (2011-2019): 101-107=Number of days per week (1 indicates weekly numb
> er), 201-230= Number of days per month (2 indicates monthly number), 777=Don't
>  know/Not sure, 888=No drink, 999=Refused, BLANK=skipped (https://www.cdc.gov/
> brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *******************Alcohol drinking questions end*******************
. 
. 
. 
. 
. *******************Smoking questions start*******************
. *Ever smoked at least 100 cigarettes in life:
. *smoke100 (1993-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. 
. 
. 
. *Currently a smoker or not:
. *smokenow (1993-1995): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/1995/pdf/layout95.pdf)
. *smokeday (1996-2004): 1=Everyday, 2=Some days, 3=Not at all, 9=Refused, BLANK
> =skipped (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK96.TXT)
. *smokday2 (2005-2019): 1=Everyday, 2=Some days, 3=Not at all, 7=Don't know/Not
>  sure, 9=Refused, BLANK=skipped (https://www.cdc.gov/brfss/annual_data/2005/pd
> f/Codebook_05.pdf)
. 
. 
. *Number of cigarettes now smoke per day:
. *smokenum (1993-2000): 1-87= Number of cigarettes (1 pack=20 cigarettes), 88=D
> on't smoke, 99=Refused (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout9
> 3.pdf)
. *(This question was not asked since 2001)
. *******************Smoking questions end*******************
. 
. 
. 
. *******************Fruit and vegetables questions start*******************
. *How often drink fruit juice?
. *fruitjui (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per 
> day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don
> ’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/
> Codebook_05.pdf)
. *fruitju1 (2011-2013, 2015): 101-199=per day, 201-299=per week, 300=Less than 
> one time per month, 301-399=per month, 555=Never, 777=Don’t know/not sure, 999
> =Refused (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *fruitju2 (2015, 2019): 101-199=per day, 201-299=per week, 300=Less than one t
> ime per month, 301-399=per month/year, 555=Never, 777=Don’t know/not sure, 999
> =Refused (https://www.cdc.gov/brfss/annual_data/2015/pdf/codebook17_llcp-v2-50
> 8.pdf)
. 
. *How often eat fruit?
. *fruit (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per day
> , 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don’t 
> know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/Cod
> ebook_05.pdf)
. *fruit1 (2011, 2013, 2015): 101-199=per day, 201-299=per week, 300=Less than o
> ne time per month, 301-399=per month, 555=Never, 777=Don’t know/not sure, 999=
> Refused (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *fruit2 (2015, 2019): 101-199=per day, 201-299=per week, 300=Less than one tim
> e per month, 301-399=per month, 555=Never, 777=Don’t know/not sure, 999=Refuse
> d (https://www.cdc.gov/brfss/annual_data/2015/pdf/codebook17_llcp-v2-508.pdf)
. 
. *How often eat green salad?
. *greensal (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per 
> day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don
> ’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/
> Codebook_05.pdf)
. 
. *How often eat potatoes (not fried)?
. *potatoes (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per 
> day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don
> ’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/
> Codebook_05.pdf)
. 
. *How often eat carrots?
. *carrots (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=per d
> ay, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=Don’
> t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pdf/C
> odebook_05.pdf)
. 
. *How often eat vegetables?
. *vegetables (1994, 1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 101-199=pe
> r day, 201-299=per week, 301-399=per month, 401-499=per year, 555=Never, 777=D
> on’t know/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2005/pd
> f/Codebook_05.pdf)
. 
. *Number of daily servings of fruits and vegetables
. *_frtserv (1994): 0-999.98=numbers of times per day, 999.99=Don’t know/refused
> /missing (https://www.cdc.gov/brfss/annual_data/1994/pdf/layout94.pdf)
. *_frtserv (1996, 1998, 2000, 2002, 2003, 2005, 2007, 2009): 0-99998=numbers of
>  times per day, 99999=Don’t know/refused/missing (last two digits correspond t
> o two decimal places) (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK
> 96.TXT)
. 
. *Number of fruit consumed per day (the two following variables' last one digit
>  should correspond to one decimal place, but the codebook mis-stated that the 
> last two digits correspond to two decimal places)
. *_frutsum (2011, 2013, 2015): 0-99998=number of times per day, Blank=not asked
> /missing (last one digit correspond to one decimal place) (https://www.cdc.gov
> /brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *_frutsu1 (2015, 2019): 0-99998=number of times per day, Blank=not asked/missi
> ng (last one digit correspond to one decimal place) (https://www.cdc.gov/brfss
> /annual_data/2015/pdf/codebook17_llcp-v2-508.pdf)
. 
. *Number of vegetables consumed per day (the two following variables' last one 
> digit should correspond to one decimal place, but the codebook mis-stated that
>  the last two digits correspond to two decimal places)
. *_vegesum (2011, 2013, 2015): 0-99998=number of times per day, Blank=not asked
> /missing (last one digit correspond to one decimal place) (https://www.cdc.gov
> /brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *_vegesu1 (2015, 2019): 0-99998=number of times per day, Blank=not asked/missi
> ng (last one digit correspond to one decimal place) (https://www.cdc.gov/brfss
> /annual_data/2015/pdf/codebook17_llcp-v2-508.pdf)
. *******************Fruit and vegetables questions end*******************
. 
. 
. *Flu shot last year?
. *flushot (1993, 1995, 1997, 1999, 2001-2003): 1=Yes, 2=No, 7=Don’t know/not su
> re, 9=Refused, Blank=Skipped (https://www.cdc.gov/brfss/annual_data/2003/pdf/C
> odebook_03.pdf)
. *flushot2 (2004): 1=Yes, 2=No, 7=Don’t know, 9=Refused (https://www.cdc.gov/br
> fss/annual_data/2004/pdf/Codebook_04.pdf)
. *flushot3 (2005-2009): 1=Yes, 2=No, 7=Don’t know, 9=Refused (https://www.cdc.g
> ov/brfss/annual_data/2005/pdf/Codebook_05.pdf)
. *flushot4 (2010): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked or mis
> sing (https://www.cdc.gov/brfss/annual_data/2010/pdf/codebook_10.pdf)
. *flushot5 (2011-2012): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked o
> r missing (https://www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. *flushot6 (2013-2018): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked o
> r missing (https://www.cdc.gov/brfss/annual_data/2013/pdf/CODEBOOK13_LLCP.pdf)
. *flushot7 (2019): 1=Yes, 2=No, 7=Don’t know, 9=Refused, Blank=Not asked or mis
> sing (https://www.cdc.gov/brfss/annual_data/2019/pdf/codebook19_llcp-v2-508.HT
> ML)
. 
. 
. *Seat belt usage
. *seatbelt (1993, 1995, 1997, 2002, 2006, 2008, 2010-2018): 1=Always, 2=Nearly 
> always, 3=Sometimes, 4=Seldom, 5=Never, 7=Don’t know/not sure, 8=Never drive o
> r ride in a car, 9=Refused, Blank=Skipped (https://www.cdc.gov/brfss/annual_da
> ta/2018/pdf/codebook18_llcp-v2-508.pdf)
. 
. 
. 
. *physical activities in last month:
. *exerany (1993-2000): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=ski
> pped (https://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *exerany2 (2001-2019): 1=Yes, 2=No, 7=Don't know/Not sure, 9=Refused, BLANK=sk
> ipped (https://www.cdc.gov/brfss/annual_data/2015/pdf/codebook17_llcp-v2-508.p
> df)
. 
. 
. *medcost (Was there a time during the last 12 months when you needed to see a 
> doctor, but could not because of the cost?):
. *medcost (1993-2001, 2003-2019): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused
>  (https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. 
. *healthcare plan (Do you have any kind of health care coverage, including heal
> th insurance, prepaid plans such as HMOs, or government plans such as Medicare
> ?):
. *hlthplan (1993-2010): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused (https://
> www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *hlthpln1 (2011-2019): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused (https://
> www.cdc.gov/brfss/annual_data/2011/pdf/CODEBOOK11_LLCP.pdf)
. 
. 
. *Medicare (Do you have Medicare?):
. *medicare (1996-1997): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused, BLANK=Sk
> ipped since answer to hlthplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/19
> 96/files/CODEBK96.TXT)
. *medicar2 (1998-2000): 1=Yes, 2=No, 7=Don't know/not sure, 9=Refused, BLANK=Sk
> ipped since answer to hlthplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/19
> 98/pdf/Codebook_98.pdf)
. 
. 
. *type of healthcare plan 1 (What type of health care coverage do you use to pa
> y for most of your medical care? Is it coverage through:):
. *typcovr1 (1996-2000): 1=Your employer, 2=Someone's employer, 3=A plan that yo
> u or someone else buys on your own, 4=Medicare, 5=Medicaid or medical assistan
> ce, 6=Military, CHAMPUS, or VA, 7=Indian Health Service, 8=Some other source, 
> 77=Don't know/not sure, 88=None, 99=Refused, BLANK=Skipped since answer to hlt
> hplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK96.TXT)
. 
. 
. *type of healthcare plan 2 (There are some types of coverage you may not have 
> considered. Please tell me if you have any of the following: (Only persons HLT
> HPLAN=2)):
. *typcovr2 (1996-2000): 1=Your employer, 2=Someone's employer, 3=A plan that yo
> u or someone else buys on your own, 4=Medicare, 5=Medicaid or medical assistan
> ce, 6=Military, CHAMPUS, or VA, 7=Indian Health Service, 8=Some other source, 
> 77=Don't know/not sure, 88=None, 99=Refused, BLANK=Skipped since answer to hlt
> hplan=2,7,9 (https://www.cdc.gov/brfss/annual_data/1996/files/CODEBK96.TXT)
. 
. 
. 
. 
. *height:
. *htf (height in feet) (1993-2000): 2-6=Number of feet, 7=7 feet or Don't know/
> not sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/1994/pdf/layout94.p
> df)
. *htm (height in meters) (2001-2002): 999=Don't know/refused/missing (https://w
> ww.cdc.gov/brfss/annual_data/2002/pdf/codebook_02.pdf)
. *htm2 (height in meters) (2003): 999=Don't know/refused/missing (https://www.c
> dc.gov/brfss/annual_data/2003/pdf/Codebook_03.pdf)
. *htm3 (height in meters) (2004-2010): 999=Don't know/refused/missing (https://
> www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *htm4 (height in meters) (2011-2019) (https://www.cdc.gov/brfss/annual_data/20
> 11/pdf/CODEBOOK11_LLCP.pdf)
. *hti (height in inches) (1993-2000): 77=Don't know/not sure, 99=Refused (https
> ://www.cdc.gov/brfss/annual_data/2000/pdf/codebook_00.pdf)
. *htin (height in inches) (2001-2002): 99=Don't know/refused/missing (https://w
> ww.cdc.gov/brfss/annual_data/2002/pdf/codebook_02.pdf)
. *htin2 (height in inches) (2003): 999=Don't know/refused/missing (https://www.
> cdc.gov/brfss/annual_data/2003/pdf/Codebook_03.pdf)
. *htin3 (height in inches) (2004-2010): 999=Don't know/refused/missing (https:/
> /www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.pdf)
. *htin4 (height in inches) (2011-2019) (https://www.cdc.gov/brfss/annual_data/2
> 011/pdf/CODEBOOK11_LLCP.pdf)
. *height (height in feet and inches, 3-digit number) (1993-2003): 777=Don't kno
> w/not sure, 999=Refused (https://www.cdc.gov/brfss/annual_data/2001/pdf/codebo
> ok_01.pdf)
. *height2 (height in feet and inches or in meters and centimeters, 3-digit numb
> er for feet and inches (<777), 4-digit number for meters and centimeters) (200
> 4): 777=Don't know/not sure, 999=Refused, 7777=Don't know/not sure, 9999=Refus
> ed, BLANK=Missing (https://www.cdc.gov/brfss/annual_data/2004/pdf/Codebook_04.
> pdf)
. *height3 (height in feet and inches or in meters and centimeters, 3-digit numb
> er for feet and inches, 4-digit number for meters and centimeters) (2005-2019)
> : 7777=Don't know/not sure, 9999=Refused, BLANK=Not asked/missing (https://www
> .cdc.gov/brfss/annual_data/2005/pdf/Codebook_05.pdf)
. 
. 
. *weight:
. *weight (weight in pounds) (1993-2003): 777=Don't know/Not sure, 999=Refused (
> https://www.cdc.gov/brfss/annual_data/1993/pdf/layout93.pdf)
. *weight2 (weight in pounds or kilograms) (2004-2019): 3-digit number for weigh
> t in pounds, 4-digit number for weight in kilograms, 777=Don't know/not sure, 
> 7777=Don't know/not sure, 9999=Refused (https://www.cdc.gov/brfss/annual_data/
> 2004/pdf/Codebook_04.pdf)
. 
. *education:
. *educa (1993-2019): 1=Never attended school/kindergarten only, 2=Elementary, 3
> =Some high school, 4=High school graduate, 5=Some college/technical school, 6=
> College graduate or more, 9=Refused (https://www.cdc.gov/brfss/annual_data/199
> 3/pdf/layout93.pdf)
. 
. 
. *income:
. *income (1993): 1=less than 10K, 2=10K to less than 15K, 3=15K to less than 20
> K, 4=20K to less than 25K, 5= 25K to less than 35K, 6=35K to 50K, 7=Over 50K, 
> 8=Don't know/not sure, 9=Refused (https://www.cdc.gov/brfss/annual_data/1993/p
> df/layout93.pdf)
. *income (1994): 1=less than 10K, 2=10K to less than 15K, 3=15K to less than 20
> K, 4=20K to less than 25K, 5= 25K to less than 35K, 6=35K to less than 50K, 7=
> 50K to 75K, 8=Over 75K, 77=Don't know/not sure, 99=Refused (https://www.cdc.go
> v/brfss/annual_data/1994/pdf/layout94.pdf)
. *income95 (1995): 1=less than 10K, 2=10K to 14999, 3=15K to 19999, 4=20K to 24
> 999, 5= 25K to 34999, 6=35K to 49999, 7=50K to 74999, 8=Over 75K, 77=Don't kno
> w/not sure, 99=Refused (https://www.cdc.gov/brfss/annual_data/1995/pdf/layout9
> 5.pdf)
. *income2 (1996-2019): 1=less than 10K, 2=10K to 14999, 3=15K to 19999, 4=20K t
> o 24999, 5= 25K to 34999, 6=35K to 49999, 7=50K to 74999, 8=Over 75K, 77=Don't
>  know/not sure, 99=Refused (https://www.cdc.gov/brfss/annual_data/1996/files/C
> ODEBK96.TXT)
. 
. 
. *County:
. *ctycode (1993-2010): county code in numeric form
. *ctycode1 (2011-2012): county code in numeric form
. 
. 
. *The following state-years are missing (https://www.cdc.gov/brfss/annual_data/
> all_years/states_data.htm):
. *Wyoming (FIPS: 56): 1993 (This is not documented)
. *Rhode Island (FIPS: 44): 1994 (The documentation said that Rhode Island is mi
> ssing in 1993, but it is wrong)
. *Washington DC (FIPS: 11): 1995
. *Hawaii (FIPS: 15): 2004
. *New Jersey (FIPS: 34): 2019
. 
. 
. 
. 
. 
. keep if _age80>=18 //make sure the minimum age is 18
(0 observations deleted)
r; t=0.06 4:38:14

. 
. 
. 
. *Health
. local new "srh"
r; t=0.00 4:38:14

. local old "genhlth"
r; t=0.00 4:38:14

. gen `new'=0 if `old'==5
(418,281 missing values generated)
r; t=0.06 4:38:14

. replace `new'=1 if `old'==4
(58,962 real changes made)
r; t=0.05 4:38:14

. replace `new'=2 if `old'==3
(136,975 real changes made)
r; t=0.06 4:38:14

. replace `new'=3 if `old'==2
(145,065 real changes made)
r; t=0.06 4:38:14

. replace `new'=4 if `old'==1
(76,032 real changes made)
r; t=0.04 4:38:15

. label var `new' "Self-rated health"
r; t=0.00 4:38:15

. label define `new' 0"Poor" 1"Fair" 2"Good" 3"VeryGood" 4"Excellent"
r; t=0.00 4:38:15

. numlabel `new', mask(#) add
r; t=2.24 4:38:17

. label value `new' `new'
r; t=0.01 4:38:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:17

. 
. 
. local new "badphyhlth"
r; t=0.00 4:38:17

. local old "physhlth"
r; t=0.00 4:38:17

. gen `new'=`old' if `old'<77
(283,886 missing values generated)
r; t=0.08 4:38:17

. replace `new'=0 if `old'==88
(274,143 real changes made)
r; t=0.07 4:38:17

. label var `new' "Number of days in last month with not good physical health"
r; t=0.00 4:38:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:17

. 
. 
. local new "badmenhlth"
r; t=0.00 4:38:17

. local old "menthlth"
r; t=0.00 4:38:17

. gen `new'=`old' if `old'<77
(308,484 missing values generated)
r; t=0.06 4:38:17

. replace `new'=0 if `old'==88
(301,076 real changes made)
r; t=0.07 4:38:17

. label var `new' "Number of days in last month with not good mental health"
r; t=0.00 4:38:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:17

. 
. 
. local new "actpoorhlth"
r; t=0.00 4:38:17

. local old "poorhlth"
r; t=0.00 4:38:17

. gen `new'=`old' if `old'<77
(345,362 missing values generated)
r; t=0.06 4:38:17

. replace `new'=0 if `old'==88
(125,838 real changes made)
r; t=0.05 4:38:17

. label var `new' "Number of days in last month keeping R from usual activities 
> due to poor physical/mental health"
note: label truncated to 80 characters
r; t=0.00 4:38:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:17

. 
. 
. local new "asthmadiag"
r; t=0.00 4:38:17

. local old "asthma3"
r; t=0.00 4:38:17

. gen `new'=0 if `old'==2
(60,902 missing values generated)
r; t=0.07 4:38:17

. replace `new'=1 if `old'==1
(59,409 real changes made)
r; t=0.03 4:38:17

. label var `new' "Ever told you have asthma"
r; t=0.00 4:38:17

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:17

. numlabel `new', mask(#) add
r; t=2.40 4:38:20

. label value `new' `new'
r; t=0.01 4:38:20

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:20

. 
. 
. local new "cholesteroldiag"
r; t=0.00 4:38:20

. local old "toldhi2"
r; t=0.00 4:38:20

. gen `new'=0 if `old'==2
(222,685 missing values generated)
r; t=0.07 4:38:20

. replace `new'=1 if `old'==1
(159,970 real changes made)
r; t=0.05 4:38:20

. label var `new' "Ever told you have high cholesterol"
r; t=0.00 4:38:20

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:20

. numlabel `new', mask(#) add
r; t=2.23 4:38:22

. label value `new' `new'
r; t=0.01 4:38:22

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:22

. 
. 
. local new "heartattackdiag"
r; t=0.00 4:38:22

. local old "cvdinfr4"
r; t=0.00 4:38:22

. gen `new'=0 if `old'==2
(27,701 missing values generated)
r; t=0.06 4:38:22

. replace `new'=1 if `old'==1
(25,472 real changes made)
r; t=0.04 4:38:22

. label var `new' "Ever told you have heart attack"
r; t=0.00 4:38:22

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:22

. numlabel `new', mask(#) add
r; t=2.14 4:38:24

. label value `new' `new'
r; t=0.01 4:38:24

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:24

. 
. 
. local new "heartdiseasediag"
r; t=0.00 4:38:24

. local old "cvdcrhd4"
r; t=0.00 4:38:24

. gen `new'=0 if `old'==2
(29,107 missing values generated)
r; t=0.06 4:38:24

. replace `new'=1 if `old'==1
(25,290 real changes made)
r; t=0.03 4:38:24

. label var `new' "Ever told you have heart disease"
r; t=0.00 4:38:24

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:24

. numlabel `new', mask(#) add
r; t=2.10 4:38:26

. label value `new' `new'
r; t=0.01 4:38:26

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:26

. 
. 
. local new "strokediag"
r; t=0.00 4:38:26

. local old "cvdstrk3"
r; t=0.00 4:38:26

. gen `new'=0 if `old'==2
(19,559 missing values generated)
r; t=0.07 4:38:27

. replace `new'=1 if `old'==1
(18,269 real changes made)
r; t=0.03 4:38:27

. label var `new' "Ever told you have stroke"
r; t=0.00 4:38:27

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:27

. numlabel `new', mask(#) add
r; t=2.19 4:38:29

. label value `new' `new'
r; t=0.01 4:38:29

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:29

. 
. 
. local new "diabetesdiag"
r; t=0.00 4:38:29

. local old "diabete3"
r; t=0.00 4:38:29

. gen `new'=0 if `old'>=3 & `old'<=4
(61,662 missing values generated)
r; t=0.07 4:38:29

. replace `new'=1 if `old'==1
(57,256 real changes made)
r; t=0.03 4:38:29

. label var `new' "Ever told you have diabetes"
r; t=0.00 4:38:29

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:29

. numlabel `new', mask(#) add
r; t=2.14 4:38:31

. label value `new' `new'
r; t=0.01 4:38:31

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:31

. 
. 
. local new "highbloodpressurediag"
r; t=0.00 4:38:31

. local old "bphigh4"
r; t=0.00 4:38:31

. gen `new'=0 if `old'>=3 & `old'<=4
(182,826 missing values generated)
r; t=0.08 4:38:31

. replace `new'=1 if `old'==1
(178,188 real changes made)
r; t=0.06 4:38:31

. label var `new' "Ever told you have high blood pressure"
r; t=0.00 4:38:31

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:31

. numlabel `new', mask(#) add
r; t=2.09 4:38:33

. label value `new' `new'
r; t=0.00 4:38:33

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:33

. 
. 
. local new "actlim"
r; t=0.00 4:38:33

. local old "poorhlth"
r; t=0.00 4:38:33

. gen `new'=0 if `old'<14 | `old'==88 | physhlth==88 | menthlth==88
(25,582 missing values generated)
r; t=0.07 4:38:33

. replace `new'=1 if `old'>=14 & `old'<77 //14 days cutoff from (Dwyer-Lindgren 
> et al. 2015)
(38,119 real changes made)
r; t=0.03 4:38:33

. label var `new' "Frequent activity limitation"
r; t=0.00 4:38:33

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:33

. numlabel `new', mask(#) add
r; t=1.87 4:38:35

. label value `new' `new'
r; t=0.00 4:38:35

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:35

. 
. 
. local new "walkdiff"
r; t=0.00 4:38:35

. local old "diffwalk"
r; t=0.00 4:38:35

. gen `new'=2-`old' if `old'<7
(14,594 missing values generated)
r; t=0.07 4:38:35

. label var `new' "Difficulty walking or climbing stairs"
r; t=0.00 4:38:35

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:35

. numlabel `new', mask(#) add
r; t=1.93 4:38:37

. label value `new' `new'
r; t=0.00 4:38:37

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:37

. 
. 
. local new "dressdiff"
r; t=0.00 4:38:37

. local old "diffdres"
r; t=0.00 4:38:37

. gen `new'=2-`old' if `old'<7
(13,913 missing values generated)
r; t=0.07 4:38:37

. label var `new' "Difficulty dressing or bathing"
r; t=0.00 4:38:37

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:37

. numlabel `new', mask(#) add
r; t=1.98 4:38:39

. label value `new' `new'
r; t=0.01 4:38:39

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:39

. 
. 
. local new "erranddiffalone"
r; t=0.00 4:38:39

. local old "diffalon"
r; t=0.00 4:38:39

. gen `new'=2-`old' if `old'<7
(15,238 missing values generated)
r; t=0.07 4:38:39

. label var `new' "Difficulty doing errands alone (e.g., shopping, visit doctor)
> "
r; t=0.00 4:38:39

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:39

. numlabel `new', mask(#) add
r; t=1.81 4:38:41

. label value `new' `new'
r; t=0.01 4:38:41

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:41

. 
. 
. local new "funclimit"
r; t=0.00 4:38:41

. local old1 "actlim"
r; t=0.00 4:38:41

. local old2 "walkdiff"
r; t=0.00 4:38:41

. local old3 "dressdiff"
r; t=0.00 4:38:41

. local old4 "erranddiffalone"
r; t=0.00 4:38:41

. gen `new'=`old1' +`old2' + `old3' + `old4'
(19,490 missing values generated)
r; t=0.06 4:38:41

. label var `new' "Functional limitation index"
r; t=0.00 4:38:41

. note `new': Original: `old1' `old2' `old3' `old4' | `tag'
r; t=0.00 4:38:41

. 
. 
. 
. 
. 
. 
. *Health behaviors
. local new "bodycheck"
r; t=0.00 4:38:41

. local old "checkup1"
r; t=0.00 4:38:41

. gen `new'=5-`old' if `old'<=4
(9,958 missing values generated)
r; t=0.06 4:38:41

. replace `new'=0 if `old'==8
(3,843 real changes made)
r; t=0.02 4:38:41

. label var `new' "Last time did body check up"
r; t=0.00 4:38:41

. label define `new' 0"Never" 1"5orMoreYearsAgo" 2"2-5YearsAgo" 3"1-2YearsAgo" 4
> "1-12MonthsAgo"
r; t=0.00 4:38:41

. numlabel `new', mask(#_) add
r; t=1.89 4:38:43

. label value `new' `new'
r; t=0.01 4:38:43

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:43

. 
. 
. local new "alcoholnum"
r; t=0.00 4:38:43

. local old "alcday5"
r; t=0.00 4:38:43

. gen `new'=(`old'-100)/7 if `old'>=100 & `old'<=107
(383,960 missing values generated)
r; t=0.06 4:38:43

. replace `new'=(`old'-200)/30 if `old'>=201 & `old'<=230
(153,850 real changes made)
r; t=0.06 4:38:43

. replace `new'=0 if `old'==888
(208,460 real changes made)
r; t=0.04 4:38:43

. label var `new' "Average number of days of alcohol drinking in last month"
r; t=0.00 4:38:43

. note `new': Original: `old' | `tag'
r; t=0.01 4:38:43

. 
. 
. local new "bingedrink"
r; t=0.00 4:38:43

. local old "_rfbing5"
r; t=0.00 4:38:43

. gen `new'=`old'-1 if `old'<9
(25,611 missing values generated)
r; t=0.07 4:38:43

. label var `new' "Binge drinking in last 30 days"
r; t=0.00 4:38:43

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:43

. numlabel `new', mask(#) add
r; t=1.89 4:38:45

. label value `new' `new'
r; t=0.00 4:38:45

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:45

. 
. 
. local new "heavydrink"
r; t=0.00 4:38:45

. local old "_rfdrhv5"
r; t=0.00 4:38:45

. gen `new'=`old'-1 if `old'<9
(25,733 missing values generated)
r; t=0.05 4:38:45

. label var `new' "Heavy drinking in last 30 days"
r; t=0.00 4:38:45

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:45

. numlabel `new', mask(#) add
r; t=2.15 4:38:48

. label value `new' `new'
r; t=0.01 4:38:48

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:48

. 
. 
. 
. local new "smokeever"
r; t=0.00 4:38:48

. local old "smoke100"
r; t=0.00 4:38:48

. gen `new'=0 if `old'==2
(201,848 missing values generated)
r; t=0.06 4:38:48

. replace `new'=1 if `old'==1
(184,299 real changes made)
r; t=0.03 4:38:48

. label var `new' "Ever smoke at least 100 cigarettes in life"
r; t=0.00 4:38:48

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:48

. numlabel `new', mask(#) add
r; t=1.82 4:38:49

. label value `new' `new'
r; t=0.01 4:38:50

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:50

. 
. 
. local new "smoking"
r; t=0.00 4:38:50

. local old "smokday2"
r; t=0.00 4:38:50

. gen `new'=0 if smokeever==0
(201,848 missing values generated)
r; t=0.05 4:38:50

. replace `new'=1 if `old'==3 & smokeever==1
(122,277 real changes made)
r; t=0.04 4:38:50

. replace `new'=2 if `old'==2
(17,998 real changes made)
r; t=0.02 4:38:50

. replace `new'=3 if `old'==1
(43,583 real changes made)
r; t=0.04 4:38:50

. label var `new' "How often smoke cigarettes"
r; t=0.00 4:38:50

. label define `new' 0"Never" 1"NoSmokingReg" 2"SomeDays" 3"Everyday"
r; t=0.00 4:38:50

. numlabel `new', mask(#) add
r; t=1.100 4:38:52

. label value `new' `new'
r; t=0.01 4:38:52

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:52

. 
. 
. local new "smokingsim"
r; t=0.00 4:38:52

. local old "smoking"
r; t=0.00 4:38:52

. gen `new'=0 if `old'==0
(201,848 missing values generated)
r; t=0.06 4:38:52

. replace `new'=1 if `old'==1
(122,277 real changes made)
r; t=0.03 4:38:52

. replace `new'=2 if `old'==2 | `old'==3
(61,581 real changes made)
r; t=0.03 4:38:52

. label var `new' "How often smoke cigarettes"
r; t=0.00 4:38:52

. label define `new' 0"Never" 1"NoSmokingReg" 2"SomeorEveryDay"
r; t=0.00 4:38:52

. numlabel `new', mask(#) add
r; t=1.81 4:38:54

. label value `new' `new'
r; t=0.01 4:38:54

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:54

. 
. 
. local new "vegserv" //this variable includes dark green vegetables, french fri
> es, potato, and other vegetables intake
r; t=0.00 4:38:54

. local old "_vegesum"
r; t=0.00 4:38:54

. gen `new'=`old'/100 if _vegetex==0 //exclude those who reported 24 servings or
>  more per day (too high, according to official codebook)
(51,164 missing values generated)
r; t=0.06 4:38:54

. label var `new' "Vegetables servings per day"
r; t=0.00 4:38:54

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:54

. 
. 
. local new "veg1perday"
r; t=0.00 4:38:54

. local old "vegserv"
r; t=0.00 4:38:54

. gen `new'=0 if `old'<1
(360,678 missing values generated)
r; t=0.05 4:38:54

. replace `new'=1 if `old'>=1 & !mi(`old')
(309,514 real changes made)
r; t=0.02 4:38:54

. label var `new' "1 or more vegetables servings per day"
r; t=0.00 4:38:54

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:54

. numlabel `new', mask(#) add
r; t=1.97 4:38:56

. label value `new' `new'
r; t=0.01 4:38:56

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:56

. 
. 
. local new "greenvegserv"
r; t=0.00 4:38:56

. local old "grenday_"
r; t=0.00 4:38:56

. gen `new'=`old'/100 if !mi(`old') & `old'<1000 //exclude those who reported 10
>  servings or more per day (too high)
(37,988 missing values generated)
r; t=0.07 4:38:56

. label var `new' "Dark green vegetables servings per day"
r; t=0.00 4:38:56

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:56

. 
. 
. local new "greenveg1perday"
r; t=0.00 4:38:56

. local old "greenvegserv"
r; t=0.00 4:38:56

. gen `new'=0 if `old'<1
(130,540 missing values generated)
r; t=0.05 4:38:56

. replace `new'=1 if `old'>=1 & !mi(`old')
(92,552 real changes made)
r; t=0.02 4:38:56

. label var `new' "1 or more green vegetables servings per day"
r; t=0.00 4:38:56

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:56

. numlabel `new', mask(#) add
r; t=1.98 4:38:58

. label value `new' `new'
r; t=0.01 4:38:58

. note `new': Original: `old' | `tag'
r; t=0.00 4:38:58

. 
. 
. 
. local new "othvegserv"
r; t=0.00 4:38:58

. local old "vegeda1_"
r; t=0.00 4:38:58

. gen `new'=`old'/100 if !mi(`old') & `old'<1000 //exclude those who reported 10
>  servings or more per day (too high)
(41,526 missing values generated)
r; t=0.07 4:38:58

. label var `new' "Other vegetables servings per day"
r; t=0.00 4:38:58

. note `new': Original: `old' | `tag'
r; t=0.01 4:38:58

. 
. 
. local new "otherveg1perday"
r; t=0.00 4:38:58

. local old "othvegserv"
r; t=0.00 4:38:58

. gen `new'=0 if `old'<1
(206,771 missing values generated)
r; t=0.06 4:38:58

. replace `new'=1 if `old'>=1 & !mi(`old')
(165,245 real changes made)
r; t=0.02 4:38:58

. label var `new' "1 or more other vegetables servings per day"
r; t=0.00 4:38:58

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:38:58

. numlabel `new', mask(#) add
r; t=2.29 4:39:00

. label value `new' `new'
r; t=0.01 4:39:00

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:00

. 
. 
. local new "totalfruitserv" //this variable includes fruit juice and fruit inta
> ke
r; t=0.00 4:39:00

. local old "_frutsum"
r; t=0.00 4:39:00

. gen `new'=`old'/100 if _vegetex==0 //exclude those who reported 17 servings or
>  more per day (too high, according to official codebook)
(58,881 missing values generated)
r; t=0.07 4:39:00

. label var `new' "Total fruit servings per day"
r; t=0.00 4:39:00

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:00

. 
. 
. local new "totalfruit1perday"
r; t=0.00 4:39:00

. local old "totalfruitserv"
r; t=0.00 4:39:00

. gen `new'=0 if `old'<1
(296,873 missing values generated)
r; t=0.04 4:39:00

. replace `new'=1 if `old'>=1 & !mi(`old')
(237,992 real changes made)
r; t=0.02 4:39:00

. label var `new' "1 or more total fruit servings per day"
r; t=0.00 4:39:00

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:39:00

. numlabel `new', mask(#) add
r; t=2.65 4:39:03

. label value `new' `new'
r; t=0.01 4:39:03

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:03

. 
. 
. local new "fruitjuiceserv"
r; t=0.00 4:39:03

. local old "ftjuda1_"
r; t=0.00 4:39:03

. gen `new'=`old'/100 if !mi(`old') & `old'<8000 //exclude those who reported 8 
> servings or more per day (too high)
(38,538 missing values generated)
r; t=0.10 4:39:03

. label var `new' "Fruit juice servings per day"
r; t=0.00 4:39:03

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:03

. 
. 
. local new "fruitjuice1perday"
r; t=0.00 4:39:03

. local old "fruitjuiceserv"
r; t=0.00 4:39:03

. gen `new'=0 if `old'<1
(119,189 missing values generated)
r; t=0.07 4:39:03

. replace `new'=1 if `old'>=1 & !mi(`old')
(80,651 real changes made)
r; t=0.04 4:39:03

. label var `new' "1 or more fruit juice servings per day"
r; t=0.00 4:39:03

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:39:03

. numlabel `new', mask(#) add
r; t=2.64 4:39:06

. label value `new' `new'
r; t=0.01 4:39:06

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:06

. 
. 
. local new "fruitserv"
r; t=0.00 4:39:06

. local old "frutda1_"
r; t=0.00 4:39:06

. gen `new'=`old'/100 if !mi(`old') & `old'<8000 //exclude those who reported 8 
> servings or more per day (too high)
(36,594 missing values generated)
r; t=0.09 4:39:06

. label var `new' "Fruit servings per day"
r; t=0.00 4:39:06

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:06

. 
. 
. local new "fruit1perday"
r; t=0.00 4:39:06

. local old "fruitserv"
r; t=0.00 4:39:06

. gen `new'=0 if `old'<1
(242,952 missing values generated)
r; t=0.06 4:39:06

. replace `new'=1 if `old'>=1 & !mi(`old')
(206,358 real changes made)
r; t=0.03 4:39:06

. label var `new' "1 or more fruit servings per day"
r; t=0.00 4:39:06

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:39:06

. numlabel `new', mask(#) add
r; t=2.42 4:39:09

. label value `new' `new'
r; t=0.01 4:39:09

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:09

. 
. 
. 
. local new "anyflushot"
r; t=0.00 4:39:09

. local old "flushot6"
r; t=0.00 4:39:09

. gen `new'=0 if `old'==2
(235,885 missing values generated)
r; t=0.08 4:39:09

. replace `new'=1 if `old'==1
(191,438 real changes made)
r; t=0.06 4:39:09

. label var `new' "Flu shot last year"
r; t=0.00 4:39:09

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:39:09

. numlabel `new', mask(#) add
r; t=2.50 4:39:11

. label value `new' `new'
r; t=0.01 4:39:11

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:11

. 
. 
. local new "seatbeltusage"
r; t=0.00 4:39:11

. local old "seatbelt"
r; t=0.00 4:39:11

. gen `new'=5-`old' if `old'>=1 & `old'<=5
(43,671 missing values generated)
r; t=0.09 4:39:11

. label var `new' "Seat belt usage"
r; t=0.00 4:39:11

. label define `new' 0"Never" 1"Seldom" 2"Sometimes" 3"Nearly always" 4"Always"
r; t=0.00 4:39:11

. numlabel `new', mask(#) add
r; t=2.07 4:39:13

. label value `new' `new'
r; t=0.04 4:39:13

. note `new': Original: `old' | `tag'
r; t=0.03 4:39:13

. 
. 
. local new "weightinkg"
r; t=0.00 4:39:13

. local old "weight2"
r; t=0.00 4:39:13

. gen `new'=`old'*0.45359237 if `old'<777
(31,779 missing values generated)
r; t=0.06 4:39:13

. replace `new'=`old'-9000 if `old'>7777 & `old'<9999
(861 real changes made)
r; t=0.02 4:39:14

. label var `new' "Weight (kg)"
r; t=0.00 4:39:14

. note `new': Original: `old' | `tag'
r; t=0.03 4:39:14

. 
. 
. local new "heightinmeter"
r; t=0.00 4:39:14

. local old "height3"
r; t=0.00 4:39:14

. gen `new'=real(substr(string(`old'), 1, 1))/3.2808+real(substr(string(`old'), 
> 2, 2))/39.37 if `old'<777
(17,254 missing values generated)
r; t=0.46 4:39:14

. replace `new'=(`old'-9000)/100 if `old'>7777 & `old'<9230
(1,834 real changes made)
r; t=0.03 4:39:14

. label var `new' "Height (m)"
r; t=0.00 4:39:14

. note `new': Original: `old' | `tag'
r; t=0.02 4:39:14

. 
. 
. local new "bmi"
r; t=0.00 4:39:14

. local old "_bmi5"
r; t=0.00 4:39:14

. gen `new'=`old'/100 if !mi(`old')
(36,398 missing values generated)
r; t=0.06 4:39:14

. label var `new' "Body mass index"
r; t=0.00 4:39:14

. note `new': Original: `old' | `tag'
r; t=0.03 4:39:14

. 
. 
. local new "bmicat"
r; t=0.00 4:39:14

. local old "_bmi5cat"
r; t=0.00 4:39:14

. gen `new'=`old'-1 if `old'<=4
(36,398 missing values generated)
r; t=0.05 4:39:14

. label var `new' "BMI category"
r; t=0.00 4:39:14

. label define `new' 0"Underweight" 1"Normal" 2"Overweight" 3"Obese"
r; t=0.00 4:39:14

. numlabel `new', mask(#) add
r; t=2.45 4:39:17

. label value `new' `new'
r; t=0.01 4:39:17

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:17

. 
. 
. 
. 
. 
. 
. *Physical activity
. local new "exercise"
r; t=0.00 4:39:17

. local old "exerany2"
r; t=0.00 4:39:17

. gen `new'=0 if `old'==2
(334,012 missing values generated)
r; t=0.07 4:39:17

. replace `new'=1 if `old'==1
(296,020 real changes made)
r; t=0.07 4:39:17

. label var `new' "Any exercise (except regular job) last month"
r; t=0.00 4:39:17

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:39:17

. numlabel `new', mask(#) add
r; t=19.83 4:39:37

. label value `new' `new'
r; t=0.01 4:39:37

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:37

. 
. 
. local new "exercise1type"
r; t=0.00 4:39:37

. local old "exract11"
r; t=0.00 4:39:37

. gen `new'=`old' if `old'<77
(158,925 missing values generated)
r; t=0.13 4:39:37

. label var `new' "Type of physical activity"
r; t=0.00 4:39:37

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:37

. 
. 
. local new "exercise1freq"
r; t=0.00 4:39:37

. local old "exeroft1"
r; t=0.00 4:39:37

. gen `new'=`old' if `old'>=101 & `old'<=199
(233,943 missing values generated)
r; t=0.09 4:39:37

. replace `new'=`old'/4 if `old'>=201 & `old'<=299
(83,652 real changes made)
r; t=0.05 4:39:37

. label var `new' "Frequency of exercise (times per week)"
r; t=0.00 4:39:37

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:37

. 
. 
. local new "exercise1min"
r; t=0.00 4:39:37

. local old "exerhmm1"
r; t=0.00 4:39:37

. gen `new'=`old' if `old'<100
(278,423 missing values generated)
r; t=0.05 4:39:37

. replace `new'=int(`old'/100)*60 + mod(`old',100) if `old'>=100 & `old'<=959 & 
> `old'!=777 // int(`old'/100) extracts the hundreds digit and mod(`old',100) ex
> tracts the remainder of the number after division by 100
(124,683 real changes made)
r; t=0.06 4:39:37

. label var `new' "Usual exercise duration (minutes)"
r; t=0.00 4:39:37

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:37

. 
. 
. local new "exercise2type"
r; t=0.00 4:39:37

. local old "exract21"
r; t=0.00 4:39:37

. gen `new'=`old' if `old'<77
(259,285 missing values generated)
r; t=0.06 4:39:37

. label var `new' "Type of physical activity"
r; t=0.00 4:39:37

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:37

. 
. 
. local new "exercise2freq"
r; t=0.00 4:39:37

. local old "exeroft2"
r; t=0.00 4:39:37

. gen `new'=`old' if `old'>=101 & `old'<=199
(311,924 missing values generated)
r; t=0.06 4:39:37

. replace `new'=`old'/4 if `old'>=201 & `old'<=299
(65,164 real changes made)
r; t=0.07 4:39:37

. label var `new' "Frequency of exercise (times per week)"
r; t=0.00 4:39:37

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:37

. 
. 
. local new "exercise2min"
r; t=0.00 4:39:37

. local old "exerhmm2"
r; t=0.00 4:39:37

. gen `new'=`old' if `old'<100
(341,317 missing values generated)
r; t=0.10 4:39:37

. replace `new'=int(`old'/100)*60 + mod(`old',100) if `old'>=100 & `old'<=959 & 
> `old'!=777 // int(`old'/100) extracts the hundreds digit and mod(`old',100) ex
> tracts the remainder of the number after division by 100
(92,188 real changes made)
r; t=0.09 4:39:37

. label var `new' "Usual exercise duration (minutes)"
r; t=0.00 4:39:37

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:37

. 
. 
. local new "muscleexercise"
r; t=0.00 4:39:37

. local old "strength"
r; t=0.00 4:39:37

. gen `new'=`old' if `old'>=101 & `old'<=199
(338,705 missing values generated)
r; t=0.12 4:39:38

. replace `new'=`old'/4 if `old'>=201 & `old'<=299
(50,324 real changes made)
r; t=0.08 4:39:38

. label var `new' "Frequency of muscle-strengthening exercise (times per week)"
r; t=0.00 4:39:38

. note `new': Original: `old' | `tag'
r; t=0.00 4:39:38

. 
. 
. local new "exe_total_min"
r; t=0.00 4:39:38

. local old1 "pa1min_"
r; t=0.00 4:39:38

. local old2 "exercise"
r; t=0.00 4:39:38

. gen `new'=`old1' if !mi(`old1')
(152,419 missing values generated)
r; t=0.12 4:39:38

. replace `new'=0 if `old2'==0
(107,444 real changes made)
r; t=0.08 4:39:38

. label var `new' "Minutes of the two reported exercises per week (last month)"
r; t=0.00 4:39:38

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:39:38

. 
. 
. local new "exe1_intensity"
r; t=0.00 4:39:38

. local old1 "actin11_"
r; t=0.00 4:39:38

. local old2 "exercise"
r; t=0.00 4:39:38

. gen `new'=`old1'+1
(150,022 missing values generated)
r; t=0.10 4:39:38

. replace `new'=0 if `old2'==0
(107,444 real changes made)
r; t=0.09 4:39:38

. label var `new' "Intensity of 1st reported type of exercise in last month"
r; t=0.00 4:39:38

. label define `new' 0"NoExercise" 1"LightExercise" 2"ModerateExercise" 3"Vigoro
> usExercise"
r; t=0.00 4:39:38

. numlabel `new', mask(#) add
r; t=7.54 4:39:46

. label value `new' `new'
r; t=0.01 4:39:46

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:39:46

. 
. 
. local new "exe2_intensity"
r; t=0.00 4:39:46

. local old1 "actin21_"
r; t=0.00 4:39:46

. local old2 "exercise"
r; t=0.00 4:39:46

. gen `new'=`old1'+1 //Note that respondents who reported only the 1st but not 2
> nd exercise are coded as missing
(154,872 missing values generated)
r; t=0.18 4:39:46

. replace `new'=0 if `old2'==0
(107,444 real changes made)
r; t=0.06 4:39:46

. label var `new' "Intensity of 2nd reported type of exercise in last month"
r; t=0.00 4:39:46

. label define `new' 0"NoExercise" 1"LightExercise" 2"ModerateExercise" 3"Vigoro
> usExercise"
r; t=0.00 4:39:46

. numlabel `new', mask(#) add
r; t=2.42 4:39:48

. label value `new' `new'
r; t=0.01 4:39:48

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:39:48

. 
. 
. local new "exe_intensity"
r; t=0.00 4:39:48

. local old1 "exe1_intensity"
r; t=0.00 4:39:48

. local old2 "exe2_intensity"
r; t=0.00 4:39:48

. gen `new'=0 if `old1'==0 & `old2'==0
(334,012 missing values generated)
r; t=0.09 4:39:48

. replace `new'=1 if `old1'==1 & mi(`old2')
(122 real changes made)
r; t=0.06 4:39:48

. replace `new'=2 if `old1'==2 & mi(`old2')
(3,241 real changes made)
r; t=0.07 4:39:48

. replace `new'=3 if `old1'==3 & mi(`old2')
(1,487 real changes made)
r; t=0.07 4:39:49

. replace `new'=4 if `old1'==1 & `old2'==1
(2,311 real changes made)
r; t=0.08 4:39:49

. replace `new'=5 if (`old1'==1 & `old2'==2) | (`old1'==2 & `old2'==1)
(89,663 real changes made)
r; t=0.09 4:39:49

. replace `new'=6 if (`old1'==1 & `old2'==3) | (`old1'==3 & `old2'==1)
(35,931 real changes made)
r; t=0.10 4:39:49

. replace `new'=7 if `old1'==2 & `old2'==2
(55,649 real changes made)
r; t=0.07 4:39:49

. replace `new'=8 if (`old1'==2 & `old2'==3) | (`old1'==3 & `old2'==2)
(67,490 real changes made)
r; t=0.07 4:39:49

. replace `new'=9 if `old1'==3 & `old2'==3
(35,540 real changes made)
r; t=0.05 4:39:49

. label var `new' "Intensity of two reported types of exercise in last month"
r; t=0.00 4:39:49

. label define `new' 0"NoExercise" 1"OneLightEx" 2"OneModEx" 3"OneVigEx" 4"TwoLi
> ghtEx" ///
> 5"Light&ModEx" 6"Light&VigEx" 7"TwoModEx" 8"Mod&VigEx" 9"TwoVigEx"
r; t=0.00 4:39:49

. numlabel `new', mask(#) add
r; t=2.85 4:39:52

. label value `new' `new'
r; t=0.01 4:39:52

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:39:52

. 
. 
. local new "exe_intensity_sim"
r; t=0.00 4:39:52

. local old "exe_intensity"
r; t=0.00 4:39:52

. gen `new'=0 if `old'==0
(334,012 missing values generated)
r; t=0.10 4:39:52

. replace `new'=1 if `old'>=1 & `old'<=4
(7,161 real changes made)
r; t=0.08 4:39:52

. replace `new'=2 if `old'==5
(89,663 real changes made)
r; t=0.07 4:39:52

. replace `new'=3 if `old'==6
(35,931 real changes made)
r; t=0.07 4:39:52

. replace `new'=4 if `old'==7
(55,649 real changes made)
r; t=0.06 4:39:52

. replace `new'=5 if `old'==8
(67,490 real changes made)
r; t=0.06 4:39:52

. replace `new'=6 if `old'==9
(35,540 real changes made)
r; t=0.07 4:39:52

. label var `new' "Intensity of two reported types of exercise in last month"
r; t=0.00 4:39:52

. label define `new' 0"NoExercise" 1"OneExOrTwoLight" 2"Light&ModEx" 3"Light&Vig
> Ex" 4"TwoModEx" 5"Mod&VigEx" 6"TwoVigEx"
r; t=0.00 4:39:52

. numlabel `new', mask(#) add
r; t=2.32 4:39:55

. label value `new' `new'
r; t=0.01 4:39:55

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:39:55

. 
. 
. local new "exe_intensity_simplest"
r; t=0.00 4:39:55

. local old "exe_intensity_sim"
r; t=0.00 4:39:55

. gen `new'=0 if `old'==0
(334,012 missing values generated)
r; t=0.09 4:39:55

. replace `new'=1 if `old'>=1 & `old'<=4
(188,404 real changes made)
r; t=0.08 4:39:55

. replace `new'=2 if `old'==5
(67,490 real changes made)
r; t=0.06 4:39:55

. replace `new'=3 if `old'==6
(35,540 real changes made)
r; t=0.07 4:39:55

. label var `new' "Intensity of two reported types of exercise in last month"
r; t=0.00 4:39:55

. label define `new' 0"NoExercise" 1"TwoModExOrBelow" 2"Mod&VigEx" 3"TwoVigEx"
r; t=0.00 4:39:55

. numlabel `new', mask(#) add
r; t=2.37 4:39:57

. label value `new' `new'
r; t=0.01 4:39:57

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:39:57

. 
. 
. 
. local new "exe1_freq"
r; t=0.00 4:39:57

. local old1 "pafreq1_"
r; t=0.00 4:39:57

. local old2 "exercise"
r; t=0.00 4:39:57

. gen `new'=`old1'/1000 if !mi(`old1')
(150,291 missing values generated)
r; t=0.15 4:39:58

. replace `new'=0 if `old2'==0
(107,444 real changes made)
r; t=0.07 4:39:58

. replace `new'=. if `old1'==99000
(18 real changes made, 18 to missing)
r; t=0.06 4:39:58

. label var `new' "Frequency of 1st reported type of exercise per week (last mon
> th)"
r; t=0.00 4:39:58

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:39:58

. 
. 
. local new "exe2_freq"
r; t=0.00 4:39:58

. local old1 "pafreq2_"
r; t=0.00 4:39:58

. local old2 "exercise"
r; t=0.00 4:39:58

. local old3 "exe2_intensity"
r; t=0.00 4:39:58

. gen `new'=`old1'/1000 if !mi(`old1')
(246,760 missing values generated)
r; t=0.13 4:39:58

. replace `new'=0 if `old2'==0 | mi(`old3') //Respondents who reported the 1st b
> ut not the 2nd exercise are coded as 0
(154,872 real changes made)
r; t=0.08 4:39:58

. replace `new'=. if `old1'==99000
(22 real changes made, 22 to missing)
r; t=0.06 4:39:58

. label var `new' "Frequency of 1st reported type of exercise per week (last mon
> th)"
r; t=0.00 4:39:58

. note `new': Original: `old1' `old2' `old3' | `tag'
r; t=0.00 4:39:58

. 
. 
. local new "exe1_min_per_week"
r; t=0.00 4:39:58

. local old1 "_minac11"
r; t=0.00 4:39:58

. local old2 "exercise"
r; t=0.00 4:39:58

. gen `new'=`old1' if !mi(`old1')
(155,539 missing values generated)
r; t=0.12 4:39:58

. replace `new'=4000 if `new'>=4000 & !mi(`new') //Top code the responses to be 
> 4000 minutes per week.
(129 real changes made)
r; t=0.07 4:39:58

. replace `new'=0 if `old2'==0
(107,444 real changes made)
r; t=0.07 4:39:58

. label var `new' "Minutes of 1st reported type of exercise per week (last month
> )"
r; t=0.00 4:39:58

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:39:58

. 
. 
. xtile exe1_min_quartile=exe1_min_per_week, nq(4)
r; t=5.12 4:40:03

. xtile exe1_min_quintile=exe1_min_per_week, nq(5)
r; t=5.35 4:40:09

. xtile exe1_min_sextile=exe1_min_per_week, nq(6)
r; t=5.77 4:40:14

. xtile exe1_min_dectile=exe1_min_per_week, nq(10)
r; t=6.47 4:40:21

. 
. 
. local new "exe2_min_per_week"
r; t=0.00 4:40:21

. local old1 "_minac21"
r; t=0.00 4:40:21

. local old2 "exercise"
r; t=0.00 4:40:21

. local old3 "exe2_intensity"
r; t=0.00 4:40:21

. gen `new'=`old1' if !mi(`old1')
(157,802 missing values generated)
r; t=0.13 4:40:21

. replace `new'=4000 if `new'>=4000 & !mi(`new') //Top code the responses to be 
> 4000 minutes per week.
(108 real changes made)
r; t=0.08 4:40:21

. replace `new'=0 if `old2'==0 | mi(`old3') //Respondents who reported the 1st b
> ut not the 2nd exercise are coded as 0
(153,555 real changes made)
r; t=0.10 4:40:21

. label var `new' "Minutes of 2nd reported type of exercise per week (last month
> )"
r; t=0.00 4:40:21

. note `new': Original: `old1' `old2' `old3' | `tag'
r; t=0.00 4:40:21

. 
. xtile exe2_min_quartile=exe2_min_per_week, nq(4)
r; t=5.05 4:40:26

. xtile exe2_min_quintile=exe2_min_per_week, nq(5)
r; t=6.18 4:40:32

. xtile exe2_min_sextile=exe2_min_per_week, nq(6)
r; t=5.59 4:40:38

. xtile exe2_min_dectile=exe2_min_per_week, nq(10)
r; t=6.46 4:40:44

. 
. 
. local new "strength_exe_freq"
r; t=0.00 4:40:44

. local old "strfreq_"
r; t=0.00 4:40:44

. gen `new'=`old'/1000
(44,013 missing values generated)
r; t=0.13 4:40:45

. replace `new'=. if `old'==99000
(19 real changes made, 19 to missing)
r; t=0.09 4:40:45

. label var `new' "Frequency of muscle strengthening exercise (times per week, l
> ast month)"
r; t=0.00 4:40:45

. note `new': Original: `old' | `tag'
r; t=0.00 4:40:45

. 
. xtile strength_time_tertile=strength_exe_freq, nq(3) //only tertile can be cal
> culated since the variable's distribution is very sparse.
r; t=4.79 4:40:50

. 
. 
. 
. 
. local new "exe_vigeq_min_per_week"
r; t=0.00 4:40:50

. local old1 "pa1min_"
r; t=0.00 4:40:50

. local old2 "exercise"
r; t=0.00 4:40:50

. gen `new'=`old1' if !mi(`old1')
(152,419 missing values generated)
r; t=0.13 4:40:50

. replace `new'=0 if `old2'==0
(107,444 real changes made)
r; t=0.08 4:40:50

. label var `new' "Vigorous equivalent minutes of exercise per week (last month)
> "
r; t=0.00 4:40:50

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:40:50

. 
. 
. local new "exe_vig_min_per_week"
r; t=0.00 4:40:50

. local old1 "pa1vigm_"
r; t=0.00 4:40:50

. local old2 "exercise"
r; t=0.00 4:40:50

. gen `new'=`old1' if !mi(`old1')
(150,970 missing values generated)
r; t=0.12 4:40:50

. replace `new'=0 if `old2'==0
(107,444 real changes made)
r; t=0.08 4:40:50

. label var `new' "Vigorous minutes of exercise per week (last month)"
r; t=0.00 4:40:50

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:40:50

. 
. 
. local new "exe_active" //Note: this variable is not recommended to be used sin
> ce respondents who only reported 1 type of exercise (about 2524) were excluded
>  due to lack of data to classify their overall exercise time per week
r; t=0.00 4:40:50

. local old "_pacat1"
r; t=0.00 4:40:50

. gen `new'=4-`old' if `old'<9
(55,895 missing values generated)
r; t=0.15 4:40:50

. label var `new' "Sufficient exercise per week in last month"
r; t=0.00 4:40:50

. label define `new' 0"Inactive" 1"InsufficientlyActive" 2"Active" 3"HighlyActiv
> e"
r; t=0.00 4:40:50

. numlabel `new', mask(#) add
r; t=3.03 4:40:53

. label value `new' `new'
r; t=0.01 4:40:53

. note `new': Original: `old' Exercise per week guideline reference: https://www
> .ncbi.nlm.nih.gov/books/NBK566046/ | `tag'
r; t=0.00 4:40:53

. 
. 
. local new "exe_aerobic_advice"
r; t=0.00 4:40:53

. local old "_pa150r2"
r; t=0.00 4:40:53

. gen `new'=3-`old' if `old'<9
(53,260 missing values generated)
r; t=0.16 4:40:53

. label var `new' "Meet aerobic exercise recommendations (150+ min per week) las
> t month"
r; t=0.00 4:40:53

. label define `new' 0"NoAerobicExercise" 1"Under149MinEx" 2"150+MinEx"
r; t=0.00 4:40:53

. numlabel `new', mask(#) add
r; t=2.100 4:40:56

. label value `new' `new'
r; t=0.01 4:40:56

. note `new': Original: `old' | `tag'
r; t=0.00 4:40:56

. 
. 
. local new "exe_strength_advice"
r; t=0.00 4:40:56

. local old "_pastrng"
r; t=0.00 4:40:56

. gen `new'=2-`old' if `old'<9
(44,013 missing values generated)
r; t=0.14 4:40:56

. label var `new' "Meet muscle strengthening recommendations (at least 2 times p
> er week) last month"
r; t=0.00 4:40:56

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:40:56

. numlabel `new', mask(#) add
r; t=5.01 4:41:01

. label value `new' `new'
r; t=0.01 4:41:01

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:01

. 
. 
. local new "exe_aero_strength_advice"
r; t=0.00 4:41:01

. local old "_parec1"
r; t=0.00 4:41:01

. gen `new'=4-`old' if `old'<9
(57,509 missing values generated)
r; t=0.14 4:41:02

. label var `new' "Meet areobic and muscle strengthening recommendations last mo
> nth"
r; t=0.00 4:41:02

. label define `new' 0"Neither" 1"StrengtheningOnly" 2"AerobicOnly" 3"Both"
r; t=0.00 4:41:02

. numlabel `new', mask(#) add
r; t=5.70 4:41:07

. label value `new' `new'
r; t=0.03 4:41:07

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:07

. 
. 
. local new "metval1"
r; t=0.00 4:41:07

. local old1 "metvl11_"
r; t=0.00 4:41:07

. local old2 "exercise"
r; t=0.00 4:41:07

. gen `new'=`old1' if `old1'<=128
(146,892 missing values generated)
r; t=0.17 4:41:07

. replace `new'=0 if `old2'==0 //assign those who reported no regular exercise w
> ith 0 MET
(107,444 real changes made)
r; t=0.09 4:41:08

. label var `new' "Metabolic equivalents (METs) of the 1st reported exercise"
r; t=0.00 4:41:08

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:41:08

. 
. 
. local new "metval2"
r; t=0.00 4:41:08

. local old1 "metvl11_"
r; t=0.00 4:41:08

. local old2 "exercise"
r; t=0.00 4:41:08

. gen `new'=`old1' if `old1'<=128
(146,892 missing values generated)
r; t=0.15 4:41:08

. replace `new'=0 if `old2'==0 //assign those who reported no regular exercise w
> ith 0 MET
(107,444 real changes made)
r; t=0.09 4:41:08

. label var `new' "Metabolic equivalents (METs) of the 2nd reported exercise"
r; t=0.00 4:41:08

. note `new': Original: `old1' `old2' | `tag'
r; t=0.00 4:41:08

. 
. 
. local new "metval_avg"
r; t=0.00 4:41:08

. local old1 "metval1"
r; t=0.00 4:41:08

. local old2 "metval2"
r; t=0.00 4:41:08

. gen `new'=(`old1'+`old2')/2
(39,448 missing values generated)
r; t=0.09 4:41:08

. label var `new' "Average metabolic equivalents (METs) of the 2 reported exerci
> ses"
r; t=0.00 4:41:08

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:08

. 
. 
. /*
> local new "metval_quartile"
> local old "metval_avg"
> xtile `new'=`old', nq(4)
> label var `new' "Average metabolic equivalents (METs) of the 2 reported exerci
> ses"
> label define `new' 1"1stQuartile" 2"2ndQuartile" 3"3rdQuartile" 4"4thQuartile"
> numlabel `new', mask(#) add
> label value `new' `new'
> local ivarlist `ivarlist' `new'
> note `new': Original: `old' | `tag'
> */
. 
. 
. 
. 
. *Healthcare
. local new "afforddoc"
r; t=0.00 4:41:08

. local old "medcost"
r; t=0.00 4:41:08

. gen `new'=0 if `old'==2
(44,708 missing values generated)
r; t=0.15 4:41:08

. replace `new'=1 if `old'==1
(43,514 real changes made)
r; t=0.08 4:41:08

. label var `new' "Cannot see doc due to cost in last 12 months"
r; t=0.00 4:41:08

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:41:08

. numlabel `new', mask(#) add
r; t=3.54 4:41:12

. label value `new' `new'
r; t=0.01 4:41:12

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:12

. 
. 
. local new "hlthcare"
r; t=0.00 4:41:12

. local old "hlthpln1"
r; t=0.00 4:41:12

. gen `new'=0 if `old'==2
(409,396 missing values generated)
r; t=0.09 4:41:12

. replace `new'=1 if `old'==1
(407,556 real changes made)
r; t=0.09 4:41:12

. label var `new' "Any healthcare coverage (either private or public)?"
r; t=0.00 4:41:12

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:41:12

. numlabel `new', mask(#) add
r; t=3.15 4:41:15

. label value `new' `new'
r; t=0.01 4:41:15

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:15

. 
. 
. local new "hlthcare1864"
r; t=0.00 4:41:15

. local old "_hcvu651"
r; t=0.00 4:41:15

. gen `new'=0 if `old'==2
(411,795 missing values generated)
r; t=0.11 4:41:15

. replace `new'=1 if `old'==1
(252,542 real changes made)
r; t=0.11 4:41:15

. label var `new' "Any healthcare coverage? (18-64 years old only)"
r; t=0.00 4:41:15

. label define `new' 0"No" 1"Yes"
r; t=0.00 4:41:15

. numlabel `new', mask(#) add
r; t=3.05 4:41:18

. label value `new' `new'
r; t=0.03 4:41:18

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:18

. 
. 
. 
. 
. 
. *Sociodemographic variables
. local new "oxygen_max"
r; t=0.00 4:41:18

. local old "maxvo2_"
r; t=0.00 4:41:18

. gen `new'=`old'/100 if `old'<99900
(5,336 missing values generated)
r; t=0.18 4:41:19

. label var `new' "Estimated Maximum Oxygen Consumption (mL/kg/min)"
r; t=0.00 4:41:19

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:19

. 
. 
. local new "yearsold"
r; t=0.00 4:41:19

. local old "_age80"
r; t=0.00 4:41:19

. gen `new'=`old' if `old'<=80
r; t=0.15 4:41:19

. label var `new' "Age"
r; t=0.00 4:41:19

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:19

. 
. 
. 
. local new "agegroup"
r; t=0.00 4:41:19

. local old "yearsold"
r; t=0.00 4:41:19

. gen `new'=0 if `old'>=18 & `old'<=20
(431,632 missing values generated)
r; t=0.10 4:41:19

. replace `new'=1 if `old'>=21 & `old'<=25
(18,506 real changes made)
r; t=0.08 4:41:19

. replace `new'=2 if `old'>=26 & `old'<=30
(20,300 real changes made)
r; t=0.07 4:41:19

. replace `new'=3 if `old'>=31 & `old'<=35
(23,671 real changes made)
r; t=0.08 4:41:19

. replace `new'=4 if `old'>=36 & `old'<=40
(24,842 real changes made)
r; t=0.08 4:41:19

. replace `new'=5 if `old'>=41 & `old'<=45
(26,937 real changes made)
r; t=0.08 4:41:19

. replace `new'=6 if `old'>=46 & `old'<=50
(33,308 real changes made)
r; t=0.08 4:41:19

. replace `new'=7 if `old'>=51 & `old'<=55
(41,773 real changes made)
r; t=0.08 4:41:19

. replace `new'=8 if `old'>=56 & `old'<=60
(47,764 real changes made)
r; t=0.09 4:41:19

. replace `new'=9 if `old'>=61 & `old'<=65
(52,129 real changes made)
r; t=0.09 4:41:19

. replace `new'=10 if `old'>=66 & `old'<=70
(47,504 real changes made)
r; t=0.09 4:41:20

. replace `new'=11 if `old'>=71 & `old'<=75
(36,634 real changes made)
r; t=0.08 4:41:20

. replace `new'=12 if `old'>=76 & `old'<=80
(58,264 real changes made)
r; t=0.08 4:41:20

. label var `new' "Age Group"
r; t=0.00 4:41:20

. label define `new' 0"18-20" 1"21-25" 2"26-30" 3"31-35" 4"36-40" 5"41-45" 6"46-
> 50" 7"51-55" 8"56-60" 9"61-65" 10"66-70" 11"71-75" 12"76-80"
r; t=0.00 4:41:20

. numlabel `new', mask(#_) add
r; t=2.67 4:41:22

. label value `new' `new'
r; t=0.00 4:41:22

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:22

. 
. 
. local new "agegroup_sim"
r; t=0.00 4:41:22

. local old "agegroup"
r; t=0.00 4:41:22

. gen `new'=0 if `old'>=0 & `old'<=4
(344,313 missing values generated)
r; t=0.09 4:41:23

. replace `new'=1 if `old'>=5 & `old'<=9
(201,911 real changes made)
r; t=0.09 4:41:23

. replace `new'=2 if `old'>=10 & `old'<=12
(142,402 real changes made)
r; t=0.08 4:41:23

. label var `new' "Age Group"
r; t=0.00 4:41:23

. label define `new' 0"18-40" 1"41-65" 2"66-80"
r; t=0.00 4:41:23

. numlabel `new', mask(#_) add
r; t=2.45 4:41:25

. label value `new' `new'
r; t=0.02 4:41:25

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:25

. 
. 
. local new "educ"
r; t=0.00 4:41:25

. local old "educa"
r; t=0.00 4:41:25

. gen `new'=0 if `old'>=1 & `old'<=3
(407,197 missing values generated)
r; t=0.12 4:41:25

. replace `new'=1 if `old'==4
(123,227 real changes made)
r; t=0.08 4:41:25

. replace `new'=2 if `old'==5
(120,528 real changes made)
r; t=0.08 4:41:25

. replace `new'=3 if `old'==6
(161,631 real changes made)
r; t=0.09 4:41:26

. label var `new' "Education"
r; t=0.00 4:41:26

. label define `new' 0"BelowHighSch" 1"HighSch" 2"SomeCollege" 3"CollegeorAbove"
r; t=0.00 4:41:26

. numlabel `new', mask(#) add
r; t=2.49 4:41:28

. label value `new' `new'
r; t=0.02 4:41:28

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:28

. 
. 
. local new "edu"
r; t=0.00 4:41:28

. local old "educa"
r; t=0.00 4:41:28

. gen `new'=0 if `old'>=1 & `old'<=4
(283,970 missing values generated)
r; t=0.12 4:41:28

. replace `new'=1 if `old'==5
(120,528 real changes made)
r; t=0.07 4:41:28

. replace `new'=2 if `old'==6
(161,631 real changes made)
r; t=0.08 4:41:28

. label var `new' "Education"
r; t=0.00 4:41:28

. label define `new' 0"HighSchorBelow" 1"SomeCollege" 2"CollegeorAbove"
r; t=0.00 4:41:28

. numlabel `new', mask(#) add
r; t=2.97 4:41:31

. label value `new' `new'
r; t=0.01 4:41:31

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:31

. 
. 
. local new "employstatus_full"
r; t=0.00 4:41:31

. local old "employ1"
r; t=0.00 4:41:31

. gen `new'=0 if `old'>=1 & `old'<=2
(225,684 missing values generated)
r; t=0.14 4:41:31

. replace `new'=1 if `old'>=3 & `old'<=4
(18,606 real changes made)
r; t=0.08 4:41:31

. replace `new'=2 if `old'==5
(27,107 real changes made)
r; t=0.07 4:41:32

. replace `new'=3 if `old'==6
(11,551 real changes made)
r; t=0.07 4:41:32

. replace `new'=4 if `old'==7
(132,648 real changes made)
r; t=0.08 4:41:32

. replace `new'=5 if `old'==8
(31,977 real changes made)
r; t=0.07 4:41:32

. label var `new' "Employment Status"
r; t=0.00 4:41:32

. label define `new' 0"Employed" 1"Unemployed" 2"Homemaker" 3"Student" 4"Retired
> " 5"UnabletoWork"
r; t=0.00 4:41:32

. numlabel `new', mask(#) add
r; t=2.67 4:41:34

. label value `new' `new'
r; t=0.01 4:41:34

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:34

. 
. 
. 
. local new "employstatus"
r; t=0.00 4:41:34

. local old "employ1"
r; t=0.00 4:41:34

. gen `new'=0 if `old'>=1 & `old'<=2
(225,684 missing values generated)
r; t=0.13 4:41:35

. replace `new'=1 if `old'>=3 & `old'<=4
(18,606 real changes made)
r; t=0.08 4:41:35

. replace `new'=2 if `old'>=5 & `old'<=8
(203,283 real changes made)
r; t=0.11 4:41:35

. label var `new' "Employment Status"
r; t=0.00 4:41:35

. label define `new' 0"Employed" 1"Unemployed" 2"Other"
r; t=0.00 4:41:35

. numlabel `new', mask(#) add
r; t=2.91 4:41:38

. label value `new' `new'
r; t=0.01 4:41:38

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:38

. 
. 
. local new "male"
r; t=0.00 4:41:38

. local old "sex"
r; t=0.00 4:41:38

. gen `new'=0 if `old'==2
(186,938 missing values generated)
r; t=0.12 4:41:38

. replace `new'=1 if `old'==1
(186,938 real changes made)
r; t=0.09 4:41:38

. label var `new' "Sex"
r; t=0.00 4:41:38

. label define `new' 0"Female" 1"Male"
r; t=0.00 4:41:38

. numlabel `new', mask(#) add
r; t=2.90 4:41:41

. label value `new' `new'
r; t=0.01 4:41:41

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:41

. 
. 
. local new "hispanic"
r; t=0.00 4:41:41

. local old "_hispanc"
r; t=0.00 4:41:41

. gen `new'=2-`old' if `old'<9
(4,136 missing values generated)
r; t=0.18 4:41:41

. label var `new' "Hispanic"
r; t=0.00 4:41:41

. label define `new' 0"Non-Hispanic" 1"Hispanic"
r; t=0.00 4:41:41

. numlabel `new', mask(#) add
r; t=3.15 4:41:44

. label value `new' `new'
r; t=0.01 4:41:44

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:44

. 
. 
. local new "prace"
r; t=0.00 4:41:44

. local old "_prace1"
r; t=0.00 4:41:44

. gen `new'=0 if `old'==1
(78,255 missing values generated)
r; t=0.13 4:41:44

. replace `new'=1 if `old'==2
(36,873 real changes made)
r; t=0.07 4:41:44

. replace `new'=2 if `old'==3
(8,722 real changes made)
r; t=0.07 4:41:44

. replace `new'=3 if `old'==4
(10,894 real changes made)
r; t=0.07 4:41:45

. replace `new'=4 if `old'==5
(2,901 real changes made)
r; t=0.07 4:41:45

. replace `new'=5 if `old'>=6 & `old'<=8
(10,050 real changes made)
r; t=0.09 4:41:45

. label var `new' "Preferred Racial Group"
r; t=0.00 4:41:45

. label define `new' 0"White" 1"Black" 2"NativeAm" 3"Asian" 4"NativeHawaiianPacI
> slander" 5"Other"
r; t=0.00 4:41:45

. numlabel `new', mask(#) add
r; t=2.43 4:41:47

. label value `new' `new'
r; t=0.01 4:41:47

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:47

. 
. 
. local new "praceethnicgpf" //Note that those who didn't respond to Hispanic qu
> estion are missing in this variable
r; t=0.00 4:41:47

. local old1 "prace"
r; t=0.00 4:41:47

. local old2 "hispanic"
r; t=0.00 4:41:47

. gen `new'=0 if `old1'==0 & `old2'==0
(101,649 missing values generated)
r; t=0.11 4:41:47

. replace `new'=1 if `old1'==1 & `old2'==0
(35,233 real changes made)
r; t=0.07 4:41:47

. replace `new'=2 if `old1'==1 & `old2'==1
(1,333 real changes made)
r; t=0.13 4:41:47

. replace `new'=3 if `old1'==0 & `old2'==1
(21,859 real changes made)
r; t=0.07 4:41:47

. replace `new'=4 if `old1'==2
(8,722 real changes made)
r; t=0.07 4:41:48

. replace `new'=5 if `old1'==3
(10,894 real changes made)
r; t=0.06 4:41:48

. replace `new'=6 if `old1'==4 & `old2'==0
(2,423 real changes made)
r; t=0.06 4:41:48

. replace `new'=7 if `old1'==4 & `old2'==1
(435 real changes made)
r; t=0.06 4:41:48

. replace `new'=8 if `old1'==5
(10,050 real changes made)
r; t=0.06 4:41:48

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:41:48

. label define `new' 0"Non-HispanicWhite" 1"Non-HispanicBlack" 2"HispanicBlack" 
> 3"HispanicWhite" 4"NativeAm" ///
> 5"Asian" 6"Non-HispanicNHPI" 7"HispanicNHPI" 8"Other"
r; t=0.00 4:41:48

. numlabel `new', mask(#) add
r; t=2.22 4:41:50

. label value `new' `new'
r; t=0.00 4:41:50

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:50

. 
. 
. local new "praceethnicgp" //Note that those who didn't respond to Hispanic que
> stion are missing in this variable
r; t=0.00 4:41:50

. local vold "praceethnicgpf"
r; t=0.00 4:41:50

. gen `new'=0 if `vold'==0
(101,649 missing values generated)
r; t=0.11 4:41:50

. replace `new'=1 if `vold'==1
(35,233 real changes made)
r; t=0.07 4:41:50

. replace `new'=2 if `vold'==2
(1,333 real changes made)
r; t=0.07 4:41:50

. replace `new'=3 if `vold'==3
(21,859 real changes made)
r; t=0.06 4:41:50

. replace `new'=4 if `vold'==6
(2,423 real changes made)
r; t=0.07 4:41:50

. replace `new'=5 if `vold'==7
(435 real changes made)
r; t=0.07 4:41:50

. replace `new'=6 if `vold'==4 | `vold'==5 | `vold'==8
(29,666 real changes made)
r; t=0.08 4:41:51

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:41:51

. label define `new' 0"WhiteNon-Hispanic" 1"Non-HispanicBlack" 2"HispanicBlack" 
> ///
> 3"HispanicWhite" 4"Non-HispanicNHPI" 5"HispanicNHPI" 6"Other"
r; t=0.00 4:41:51

. numlabel `new', mask(#) add
r; t=2.10 4:41:53

. label value `new' `new'
r; t=0.01 4:41:53

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:41:53

. 
. 
. local new "praceethnicgp_sim" //Note that I force those who responded to race 
> question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 4:41:53

. local vold1 "praceethnicgpf"
r; t=0.00 4:41:53

. local vold2 "prace"
r; t=0.00 4:41:53

. gen `new'=0 if `vold1'==0
(101,649 missing values generated)
r; t=0.11 4:41:53

. replace `new'=1 if `vold1'==1 | `vold1'==2 | `vold2'==1
(36,873 real changes made)
r; t=0.07 4:41:53

. replace `new'=2 if `vold1'==3
(21,859 real changes made)
r; t=0.07 4:41:53

. replace `new'=3 if `vold1'==6 | `vold1'==7 | `vold2'==4
(2,901 real changes made)
r; t=0.07 4:41:53

. replace `new'=4 if `vold1'==4 | `vold1'==5 | `vold1'==8 | `vold2'==2 | `vold2'
> ==3 | `vold2'==5
(29,666 real changes made)
r; t=0.09 4:41:53

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:41:53

. label define `new' 0"WhiteNon-Hispanic" 1"Black" 2"HispanicWhite" 3"NHPI" 4"Ot
> her"
r; t=0.00 4:41:53

. numlabel `new', mask(#) add
r; t=2.97 4:41:56

. label value `new' `new'
r; t=0.01 4:41:56

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:41:56

. 
. 
. 
. 
. local new "mrace"
r; t=0.00 4:41:56

. local old "_mrace1"
r; t=0.00 4:41:56

. gen `new'=0 if `old'==1
(82,283 missing values generated)
r; t=0.06 4:41:56

. replace `new'=1 if `old'==2
(35,908 real changes made)
r; t=0.02 4:41:56

. replace `new'=2 if `old'==3
(7,942 real changes made)
r; t=0.03 4:41:56

. replace `new'=3 if `old'==4
(10,117 real changes made)
r; t=0.02 4:41:56

. replace `new'=4 if `old'==5
(1,743 real changes made)
r; t=0.03 4:41:56

. replace `new'=5 if `old'==6
(8,673 real changes made)
r; t=0.02 4:41:56

. replace `new'=6 if `old'==7
(9,085 real changes made)
r; t=0.04 4:41:56

. label var `new' "Multiracial Racial Categorization"
r; t=0.00 4:41:56

. label define `new' 0"White" 1"Black" 2"NativeAm" 3"Asian" 4"NativeHawaiianPacI
> slander" 5"Other" 6"Multiracial"
r; t=0.00 4:41:56

. numlabel `new', mask(#) add
r; t=2.47 4:41:59

. label value `new' `new'
r; t=0.01 4:41:59

. note `new': Original: `old' | `tag'
r; t=0.00 4:41:59

. 
. 
. local new "mraceethnicgpf" //Note that those who didn't respond to Hispanic qu
> estion are missing in this variable
r; t=0.00 4:41:59

. local old1 "mrace"
r; t=0.00 4:41:59

. local old2 "hispanic"
r; t=0.00 4:41:59

. gen `new'=0 if `old1'==0 & `old2'==0
(105,390 missing values generated)
r; t=0.09 4:41:59

. replace `new'=1 if `old1'==1 & `old2'==0
(34,346 real changes made)
r; t=0.07 4:41:59

. replace `new'=2 if `old1'==1 & `old2'==1
(1,267 real changes made)
r; t=0.06 4:41:59

. replace `new'=3 if `old1'==0 & `old2'==1
(21,607 real changes made)
r; t=0.07 4:41:59

. replace `new'=4 if `old1'==2
(7,942 real changes made)
r; t=0.03 4:41:59

. replace `new'=5 if `old1'==3
(10,117 real changes made)
r; t=0.02 4:41:59

. replace `new'=6 if `old1'==4 & `old2'==0
(1,406 real changes made)
r; t=0.06 4:41:59

. replace `new'=7 if `old1'==4 & `old2'==1
(301 real changes made)
r; t=0.07 4:41:59

. replace `new'=8 if `old1'==5
(8,673 real changes made)
r; t=0.03 4:41:59

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:41:59

. label define `new' 0"Non-HispanicWhite" 1"Non-HispanicBlack" 2"HispanicBlack" 
> 3"HispanicWhite" 4"NativeAm" ///
> 5"Asian" 6"Non-HispanicNHPI" 7"HispanicNHPI" 8"Other"
r; t=0.00 4:41:59

. numlabel `new', mask(#) add
r; t=2.84 4:42:02

. label value `new' `new'
r; t=0.00 4:42:02

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:02

. 
. 
. local new "mraceethnicgp" //Note that those who didn't respond to Hispanic que
> stion are missing in this variable
r; t=0.00 4:42:02

. local vold "mraceethnicgpf"
r; t=0.00 4:42:02

. gen `new'=0 if `vold'==0
(105,390 missing values generated)
r; t=0.07 4:42:02

. replace `new'=1 if `vold'==1
(34,346 real changes made)
r; t=0.04 4:42:02

. replace `new'=2 if `vold'==2
(1,267 real changes made)
r; t=0.04 4:42:02

. replace `new'=3 if `vold'==3
(21,607 real changes made)
r; t=0.02 4:42:02

. replace `new'=4 if `vold'==6
(1,406 real changes made)
r; t=0.03 4:42:02

. replace `new'=5 if `vold'==7
(301 real changes made)
r; t=0.04 4:42:02

. replace `new'=6 if `vold'==4 | `vold'==5 | `vold'==8
(26,732 real changes made)
r; t=0.05 4:42:02

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:42:02

. label define `new' 0"WhiteNon-Hispanic" 1"Non-HispanicBlack" 2"HispanicBlack" 
> ///
> 3"HispanicWhite" 4"Non-HispanicNHPI" 5"HispanicNHPI" 6"Other"
r; t=0.00 4:42:02

. numlabel `new', mask(#) add
r; t=2.59 4:42:05

. label value `new' `new'
r; t=0.01 4:42:05

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:42:05

. 
. 
. local new "multiracial_mark"
r; t=0.00 4:42:05

. local old1 "_prace1"
r; t=0.00 4:42:05

. local old2 "_mrace1"
r; t=0.00 4:42:05

. gen `new'=0 if `old1'==`old2' & `old1'<77
(16,762 missing values generated)
r; t=0.07 4:42:05

. replace `new'=1 if `old1'!=`old2' & `old1'<77
(7,947 real changes made)
r; t=0.05 4:42:05

. label var `new' "Multiracial Marker"
r; t=0.00 4:42:05

. label define `new' 0"SingleRaceOrNoPreferred" 1"PreferredRaceandMultiracial"
r; t=0.00 4:42:05

. numlabel `new', mask(#) add
r; t=2.47 4:42:08

. label value `new' `new'
r; t=0.01 4:42:08

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:08

. 
. 
. local new "praceethnicgp_multi" //Note that I force those who responded to rac
> e question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 4:42:08

. local vold1 "praceethnicgp_sim"
r; t=0.00 4:42:08

. local vold2 "multiracial_mark"
r; t=0.00 4:42:08

. gen `new'=0 if `vold1'==0 & `vold2'==0
(105,390 missing values generated)
r; t=0.09 4:42:08

. replace `new'=1 if `vold1'==0 & `vold2'==1
(3,741 real changes made)
r; t=0.05 4:42:08

. replace `new'=2 if `vold1'==1 & `vold2'==0
(35,908 real changes made)
r; t=0.05 4:42:08

. replace `new'=3 if `vold1'==1 & `vold2'==1
(965 real changes made)
r; t=0.05 4:42:08

. replace `new'=4 if `vold1'==2 & `vold2'==0
(21,607 real changes made)
r; t=0.05 4:42:08

. replace `new'=5 if `vold1'==2 & `vold2'==1
(252 real changes made)
r; t=0.05 4:42:08

. replace `new'=6 if `vold1'==3 & `vold2'==0
(1,743 real changes made)
r; t=0.04 4:42:08

. replace `new'=7 if `vold1'==3 & `vold2'==1
(1,158 real changes made)
r; t=0.05 4:42:08

. replace `new'=8 if `vold1'==4 & `vold2'==0
(27,870 real changes made)
r; t=0.03 4:42:08

. replace `new'=9 if `vold1'==4 & `vold2'==1
(1,796 real changes made)
r; t=0.06 4:42:08

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:42:08

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"Black_Single" 3"Black_
> Multi" ///
> 4"HWhite_Single" 5"HWhite_Multi" 6"NHPI_Single" 7"NHPI_Multi" 8"Other_Single" 
> 9"Other_Multi"
r; t=0.00 4:42:08

. numlabel `new', mask(#) add
r; t=2.33 4:42:10

. label value `new' `new'
r; t=0.01 4:42:10

. note `new': Refer to `vold1' `vold2' | `tag'
r; t=0.00 4:42:10

. 
. 
. local new "praceethnicgp_multi_sim" //Note that I force those who responded to
>  race question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 4:42:10

. local vold "praceethnicgp_multi"
r; t=0.00 4:42:10

. gen `new'=0 if `vold'==0
(105,390 missing values generated)
r; t=0.07 4:42:10

. replace `new'=1 if `vold'==1
(3,741 real changes made)
r; t=0.02 4:42:10

. replace `new'=2 if `vold'==6
(1,743 real changes made)
r; t=0.04 4:42:11

. replace `new'=3 if `vold'==7
(1,158 real changes made)
r; t=0.04 4:42:11

. replace `new'=4 if (`vold'>=2 & `vold'<=5) | (`vold'>=8 & `vold'<=9)
(88,398 real changes made)
r; t=0.05 4:42:11

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:42:11

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"NHPI_Single" 3"NHPI_Mu
> lti" 4"Other"
r; t=0.00 4:42:11

. numlabel `new', mask(#) add
r; t=2.37 4:42:13

. label value `new' `new'
r; t=0.01 4:42:13

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:42:13

. 
. 
. local new "praceethnicgp_multi_sim2" //Note that I force those who responded t
> o race question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 4:42:13

. local vold "praceethnicgp_multi_sim"
r; t=0.00 4:42:13

. gen `new'=0 if `vold'==0 | `vold'==1
(101,649 missing values generated)
r; t=0.06 4:42:13

. replace `new'=1 if `vold'==2
(1,743 real changes made)
r; t=0.03 4:42:13

. replace `new'=2 if `vold'==3
(1,158 real changes made)
r; t=0.02 4:42:13

. replace `new'=3 if `vold'==4
(88,398 real changes made)
r; t=0.04 4:42:13

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:42:13

. label define `new' 0"nHWhite" 1"NHPI_Single" 2"NHPI_Multi" 3"Other"
r; t=0.00 4:42:13

. numlabel `new', mask(#) add
r; t=2.54 4:42:16

. label value `new' `new'
r; t=0.01 4:42:16

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:42:16

. 
. 
. local new "praceethnicgp_multi_altsim" //Note that I force those who responded
>  to race question but not Hispanic question to be either Black, NHPI, or other
r; t=0.00 4:42:16

. local vold "praceethnicgp_multi"
r; t=0.00 4:42:16

. gen `new'=0 if `vold'==0
(105,390 missing values generated)
r; t=0.07 4:42:16

. replace `new'=1 if `vold'==1
(3,741 real changes made)
r; t=0.02 4:42:16

. replace `new'=2 if `vold'==2
(35,908 real changes made)
r; t=0.03 4:42:16

. replace `new'=3 if `vold'==3
(965 real changes made)
r; t=0.02 4:42:16

. replace `new'=4 if `vold'==4 | `vold'==5
(21,859 real changes made)
r; t=0.02 4:42:16

. replace `new'=5 if `vold'==6
(1,743 real changes made)
r; t=0.03 4:42:16

. replace `new'=6 if `vold'==7
(1,158 real changes made)
r; t=0.02 4:42:16

. replace `new'=7 if `vold'==8
(27,870 real changes made)
r; t=0.03 4:42:16

. replace `new'=8 if `vold'==9
(1,796 real changes made)
r; t=0.02 4:42:16

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:42:16

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"Black_Single" 3"Black_
> Multi" 4"HWhite" 5"NHPI_Single" 6"NHPI_Multi" 7"Other_Single" 8"Other_Multi"
r; t=0.00 4:42:16

. numlabel `new', mask(#) add
r; t=2.47 4:42:18

. label value `new' `new'
r; t=0.01 4:42:18

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:42:18

. 
. 
. local new "praceethnicgp_multi_simplest" //Note that I force those who respond
> ed to race question but not Hispanic question to be either Black, NHPI, or oth
> er
r; t=0.00 4:42:18

. local vold "praceethnicgp_multi"
r; t=0.00 4:42:18

. gen `new'=0 if `vold'==0
(105,390 missing values generated)
r; t=0.06 4:42:19

. replace `new'=1 if `vold'==1
(3,741 real changes made)
r; t=0.02 4:42:19

. replace `new'=2 if `vold'>=6 & `vold'<=7
(2,901 real changes made)
r; t=0.02 4:42:19

. replace `new'=3 if (`vold'>=2 & `vold'<=5) | (`vold'>=8 & `vold'<=9)
(88,398 real changes made)
r; t=0.04 4:42:19

. label var `new' "Racial/ethnic Group"
r; t=0.00 4:42:19

. label define `new' 0"nHWhite_Single" 1"nHwhite_Multi" 2"NHPI" 3"Other"
r; t=0.00 4:42:19

. numlabel `new', mask(#) add
r; t=2.57 4:42:21

. label value `new' `new'
r; t=0.00 4:42:21

. note `new': Refer to `vold' | `tag'
r; t=0.00 4:42:21

. 
. 
. 
. local new "hhincome"
r; t=0.00 4:42:21

. local old "income2"
r; t=0.00 4:42:21

. gen `new'=0 if `old'==1
(423,007 missing values generated)
r; t=0.05 4:42:21

. replace `new'=1 if `old'==2
(19,599 real changes made)
r; t=0.02 4:42:21

. replace `new'=2 if `old'==3
(26,797 real changes made)
r; t=0.03 4:42:21

. replace `new'=3 if `old'==4
(32,377 real changes made)
r; t=0.02 4:42:21

. replace `new'=4 if `old'==5
(39,235 real changes made)
r; t=0.04 4:42:21

. replace `new'=5 if `old'==6
(52,052 real changes made)
r; t=0.04 4:42:21

. replace `new'=6 if `old'==7
(58,130 real changes made)
r; t=0.03 4:42:21

. replace `new'=7 if `old'==8
(115,312 real changes made)
r; t=0.05 4:42:21

. label var `new' "Household Income"
r; t=0.00 4:42:21

. label define `new' 0"<10000" 1"10000-14999" 2"15000-19999" 3"20000-24999" 4"25
> 000-34999" 5"35000-49999" 6"50000-74999" 7"75000+"
r; t=0.00 4:42:21

. numlabel `new', mask(#_) add
r; t=2.84 4:42:24

. label value `new' `new'
r; t=0.02 4:42:24

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:24

. 
. 
. local new "sexualorientation"
r; t=0.00 4:42:24

. local old "sxorient"
r; t=0.00 4:42:24

. gen `new'=`old'-1 if `old'<=4
(279,169 missing values generated)
r; t=0.06 4:42:24

. label var `new' "Sexual orientation"
r; t=0.00 4:42:24

. label define `new' 0"Heterosexual" 1"Homosexual" 2"Bisexual" 3"Other"
r; t=0.00 4:42:24

. numlabel `new', mask(#) add
r; t=2.72 4:42:27

. label value `new' `new'
r; t=0.02 4:42:27

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:27

. 
. 
. local new "sexualorientation_sim"
r; t=0.00 4:42:27

. local old "sexualorientation"
r; t=0.00 4:42:27

. gen `new'=0 if `old'==0
(284,257 missing values generated)
r; t=0.05 4:42:27

. replace `new'=1 if `old'>=1 & `old'<=3
(5,088 real changes made)
r; t=0.04 4:42:27

. label var `new' "Sexual orientation"
r; t=0.00 4:42:27

. label define `new' 0"Heterosexual" 1"Other"
r; t=0.00 4:42:27

. numlabel `new', mask(#) add
r; t=2.23 4:42:29

. label value `new' `new'
r; t=0.01 4:42:29

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:29

. 
. 
. 
. 
. *Technical variables
. local new "svyweight"
r; t=0.00 4:42:29

. local old "_llcpwt"
r; t=0.00 4:42:29

. gen `new'=`old'
r; t=0.05 4:42:29

. label var `new' "Survey weight"
r; t=0.00 4:42:29

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:29

. 
. 
. local new "strata"
r; t=0.00 4:42:29

. local old "_ststr"
r; t=0.00 4:42:29

. gen `new'=`old'
r; t=0.04 4:42:30

. label var `new' "Strata"
r; t=0.00 4:42:30

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:30

. 
. 
. local new "psu"
r; t=0.00 4:42:30

. local old "_psu"
r; t=0.00 4:42:30

. gen double `new'=`old'
r; t=0.03 4:42:30

. label var `new' "PSU"
r; t=0.00 4:42:30

. note `new': Original: `old' | `tag'
r; t=0.01 4:42:30

. 
. 
. local new "state"
r; t=0.00 4:42:30

. local old "_state"
r; t=0.00 4:42:30

. gen `new'=`old'
r; t=0.04 4:42:30

. label var `new' "State FIPS Code"
r; t=0.00 4:42:30

. note `new': Original: `old' | `tag'
r; t=0.01 4:42:30

. 
. 
. local new "month"
r; t=0.00 4:42:30

. local old "imonth"
r; t=0.00 4:42:30

. gen `new'=`old'
r; t=0.20 4:42:30

. label var `new' "Interview Month"
r; t=0.00 4:42:30

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:30

. 
. 
. local new "year"
r; t=0.00 4:42:30

. local old "iyear"
r; t=0.00 4:42:30

. gen `new'=`old'
r; t=0.18 4:42:30

. label var `new' "Interview Year"
r; t=0.00 4:42:30

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:30

. 
. 
. local new "interview_comp"
r; t=0.00 4:42:30

. local old "dispcode"
r; t=0.00 4:42:30

. gen `new'=0 if `old'==1200
(375,059 missing values generated)
r; t=0.05 4:42:30

. replace `new'=1 if `old'==1100
(375,059 real changes made)
r; t=0.07 4:42:30

. label var `new' "Interview Complete"
r; t=0.00 4:42:30

. label define `new' 0"PartialInterview" 1"CompletedInterview"
r; t=0.00 4:42:30

. numlabel `new', mask(#) add
r; t=2.14 4:42:32

. label value `new' `new'
r; t=0.01 4:42:32

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:32

. 
. 
. local new "metrogroup"
r; t=0.00 4:42:32

. local old "mscode"
r; t=0.00 4:42:32

. gen `new'=0 if `old'==1
(329,592 missing values generated)
r; t=0.06 4:42:32

. replace `new'=1 if `old'==2
(44,086 real changes made)
r; t=0.02 4:42:32

. replace `new'=2 if `old'==3
(18,099 real changes made)
r; t=0.03 4:42:32

. replace `new'=3 if `old'==5
(76,530 real changes made)
r; t=0.04 4:42:32

. replace `new'=4 if `old'==.
(190,877 real changes made)
r; t=0.05 4:42:32

. label var `new' "Metropolitan Status Code"
r; t=0.00 4:42:32

. label define `new' 0"CenterCityinMSA" 1"OutsideCityInCounty" 2"SuburbanCounty"
>  3"OutsideMSA" 4"GU/PR/VI/Cell"
r; t=0.00 4:42:32

. numlabel `new', mask(#) add
r; t=2.51 4:42:35

. label value `new' `new'
r; t=0.00 4:42:35

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:35

. 
. 
. 
. local new "censusdivision"
r; t=0.00 4:42:35

. local old "state"
r; t=0.00 4:42:35

. gen `new'=0 if `old'==9 | `old'==23 | `old'==25 | `old'==33 | `old'==44 | `old
> '==50
(391,483 missing values generated)
r; t=0.06 4:42:35

. replace `new'=1 if `old'==34 | `old'==36 | `old'==42
(29,562 real changes made)
r; t=0.03 4:42:35

. replace `new'=2 if `old'==17 | `old'==18 | `old'==26 | `old'==39 | `old'==55
(38,408 real changes made)
r; t=0.05 4:42:35

. replace `new'=3 if `old'==19 | `old'==20 | `old'==27 | `old'==29 | `old'==31 |
>  `old'==38 | `old'==46
(83,285 real changes made)
r; t=0.06 4:42:35

. replace `new'=4 if `old'==12 | `old'==13 | `old'==37 | `old'==45 | `old'==51 |
>  `old'==11 | `old'==24 | `old'==10 | `old'==54
(67,987 real changes made)
r; t=0.07 4:42:35

. replace `new'=5 if `old'==1  | `old'==21 | `old'==28 | `old'==47
(28,770 real changes made)
r; t=0.05 4:42:35

. replace `new'=6 if `old'==5 | `old'==22 | `old'==40 | `old'==48
(31,612 real changes made)
r; t=0.05 4:42:35

. replace `new'=7 if `old'==4 | `old'==8 | `old'==16 | `old'==30 | `old'==32 | `
> old'==35 | `old'==49 | `old'==56
(59,889 real changes made)
r; t=0.06 4:42:35

. replace `new'=8 if `old'==2 | `old'==6 | `old'==15 | `old'==41 | `old'==53
(44,896 real changes made)
r; t=0.06 4:42:35

. replace `new'=9 if `old'==66
(1,669 real changes made)
r; t=0.02 4:42:35

. replace `new'=10 if `old'==72
(5,405 real changes made)
r; t=0.04 4:42:36

. label var `new' "Census Division"
r; t=0.00 4:42:36

. label define `new' 0"NewEngland" 1"MidAtlantic" 2"ENCentral" 3"WNCentral" 4"SA
> tlantic" 5"ESCentral" 6"WSCentral" 7"Mountain" 8"Pacific" 9"Guam" 10"PuertoRic
> o"
r; t=0.00 4:42:36

. numlabel `new', mask(#) add
r; t=2.21 4:42:38

. label value `new' `new'
r; t=0.00 4:42:38

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:38

. 
. 
. local new "censusregion"
r; t=0.00 4:42:38

. local old "censusdivision"
r; t=0.00 4:42:38

. gen `new'=0 if `old'>=0 & `old'<=1
(361,921 missing values generated)
r; t=0.05 4:42:38

. replace `new'=1 if `old'>=2 & `old'<=3
(121,693 real changes made)
r; t=0.04 4:42:38

. replace `new'=2 if `old'>=4 & `old'<=6
(128,369 real changes made)
r; t=0.03 4:42:38

. replace `new'=3 if `old'>=7 & `old'<=8
(104,785 real changes made)
r; t=0.04 4:42:38

. replace `new'=4 if `old'==9
(1,669 real changes made)
r; t=0.02 4:42:38

. replace `new'=5 if `old'==10
(5,405 real changes made)
r; t=0.02 4:42:38

. label var `new' "Census Region"
r; t=0.00 4:42:38

. label define `new' 0"Northeast" 1"MidWest" 2"South" 3"West" 4"Guam" 5"PuertoRi
> co"
r; t=0.00 4:42:38

. numlabel `new', mask(#) add
r; t=2.68 4:42:41

. label value `new' `new'
r; t=0.01 4:42:41

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:41

. 
. 
. local new "censusregion_sim"
r; t=0.00 4:42:41

. local old "censusregion"
r; t=0.00 4:42:41

. gen `new'=0 if `old'>=0 & `old'<=2
(111,859 missing values generated)
r; t=0.05 4:42:41

. replace `new'=1 if `old'==3 & state!=15
(97,622 real changes made)
r; t=0.06 4:42:41

. replace `new'=2 if state==15 //Put Hawaii into a separate category
(7,163 real changes made)
r; t=0.03 4:42:41

. replace `new'=3 if `old'==4
(1,669 real changes made)
r; t=0.02 4:42:41

. replace `new'=4 if `old'==5
(5,405 real changes made)
r; t=0.03 4:42:41

. label var `new' "Census Region"
r; t=0.00 4:42:41

. label define `new' 0"Eastern" 1"West" 2"Hawaii" 3"Guam" 4"PuertoRico"
r; t=0.00 4:42:41

. numlabel `new', mask(#) add
r; t=2.14 4:42:43

. label value `new' `new'
r; t=0.01 4:42:43

. note `new': Original: `old' | `tag'
r; t=0.00 4:42:43

. 
. 
. 
. 
. 
. *For gsem estimation
. gen exe_intensity_sim_m=exe_intensity_sim if male==1
(273,287 missing values generated)
r; t=0.06 4:42:43

. gen exe_intensity_sim_f=exe_intensity_sim if male==0
(210,747 missing values generated)
r; t=0.07 4:42:43

. 
. gen exe_intensity_simplest_m=exe_intensity_simplest if male==1
(273,287 missing values generated)
r; t=0.07 4:42:43

. gen exe_intensity_simplest_f=exe_intensity_simplest if male==0
(210,747 missing values generated)
r; t=0.08 4:42:43

. 
. gen exe_aerobic_advice_m=exe_aerobic_advice if male==1
(277,373 missing values generated)
r; t=0.07 4:42:43

. gen exe_aerobic_advice_f=exe_aerobic_advice if male==0
(217,343 missing values generated)
r; t=0.07 4:42:43

. 
. gen exe_strength_advice_m=exe_strength_advice if male==1
(274,089 missing values generated)
r; t=0.06 4:42:43

. gen exe_strength_advice_f=exe_strength_advice if male==0
(211,380 missing values generated)
r; t=0.08 4:42:43

. 
. gen exe_active_m=exe_active if male==1
(278,348 missing values generated)
r; t=0.08 4:42:44

. gen exe_active_f=exe_active if male==0
(219,003 missing values generated)
r; t=0.08 4:42:44

. 
. 
. local dvlist exe_intensity_sim_m exe_intensity_sim_f exe_aerobic_advice_m exe_
> aerobic_advice_f
r; t=0.00 4:42:44

. local dvlist `dvlist' exe_strength_advice_m exe_strength_advice_f exe_active_m
>  exe_active_f exe_intensity_simplest_m exe_intensity_simplest_f
r; t=0.00 4:42:44

. foreach var in `dvlist' {
  2.         forvalues dvnum=1(1)20 {
  3.                 gen `var'`dvnum'=`var'
  4.         }
  5. }
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(277,373 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(217,343 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(274,089 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(211,380 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(278,348 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(219,003 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(273,287 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
(210,747 missing values generated)
r; t=13.83 4:42:57

. 
. /*
> *Generate census region-specific DV
> foreach var in `dvlist' {
>         local `var'_
>         forvalues dvnum=1(1)20 {
>                 gen `var'`dvnum'=`var'
>         }
> }
> */
. 
. *Generate outcomes by census region
. gen exe_intensity_sim_m_cr0=exe_intensity_sim_m if censusregion_sim==0
(317,519 missing values generated)
r; t=0.09 4:42:58

. gen exe_intensity_sim_m_cr1=exe_intensity_sim_m if censusregion_sim==1
(402,839 missing values generated)
r; t=0.06 4:42:58

. gen exe_intensity_sim_m_cr2=exe_intensity_sim_m if censusregion_sim==2
(438,442 missing values generated)
r; t=0.05 4:42:58

. gen exe_intensity_sim_m_cr3=exe_intensity_sim_m if censusregion_sim==3
(440,761 missing values generated)
r; t=0.05 4:42:58

. gen exe_intensity_sim_m_cr4=exe_intensity_sim_m if censusregion_sim==4
(439,550 missing values generated)
r; t=0.06 4:42:58

. 
. gen exe_intensity_sim_f_cr0=exe_intensity_sim_f if censusregion_sim==0
(267,356 missing values generated)
r; t=0.08 4:42:58

. gen exe_intensity_sim_f_cr1=exe_intensity_sim_f if censusregion_sim==1
(392,434 missing values generated)
r; t=0.06 4:42:58

. gen exe_intensity_sim_f_cr2=exe_intensity_sim_f if censusregion_sim==2
(438,026 missing values generated)
r; t=0.06 4:42:58

. gen exe_intensity_sim_f_cr3=exe_intensity_sim_f if censusregion_sim==3
(440,651 missing values generated)
r; t=0.05 4:42:58

. gen exe_intensity_sim_f_cr4=exe_intensity_sim_f if censusregion_sim==4
(438,104 missing values generated)
r; t=0.05 4:42:58

. 
. 
. gen exe_intensity_simplest_m_cr0=exe_intensity_simplest_m if censusregion_sim=
> =0
(317,519 missing values generated)
r; t=0.08 4:42:58

. gen exe_intensity_simplest_m_cr1=exe_intensity_simplest_m if censusregion_sim=
> =1
(402,839 missing values generated)
r; t=0.07 4:42:58

. gen exe_intensity_simplest_m_cr2=exe_intensity_simplest_m if censusregion_sim=
> =2
(438,442 missing values generated)
r; t=0.07 4:42:58

. gen exe_intensity_simplest_m_cr3=exe_intensity_simplest_m if censusregion_sim=
> =3
(440,761 missing values generated)
r; t=0.06 4:42:58

. gen exe_intensity_simplest_m_cr4=exe_intensity_simplest_m if censusregion_sim=
> =4
(439,550 missing values generated)
r; t=0.06 4:42:58

. 
. gen exe_intensity_simplest_f_cr0=exe_intensity_simplest_f if censusregion_sim=
> =0
(267,356 missing values generated)
r; t=0.08 4:42:59

. gen exe_intensity_simplest_f_cr1=exe_intensity_simplest_f if censusregion_sim=
> =1
(392,434 missing values generated)
r; t=0.07 4:42:59

. gen exe_intensity_simplest_f_cr2=exe_intensity_simplest_f if censusregion_sim=
> =2
(438,026 missing values generated)
r; t=0.05 4:42:59

. gen exe_intensity_simplest_f_cr3=exe_intensity_simplest_f if censusregion_sim=
> =3
(440,651 missing values generated)
r; t=0.05 4:42:59

. gen exe_intensity_simplest_f_cr4=exe_intensity_simplest_f if censusregion_sim=
> =4
(438,104 missing values generated)
r; t=0.04 4:42:59

. 
. 
. 
. 
. 
. gen exe_aerobic_advice_m_cr0=exe_aerobic_advice_m if censusregion_sim==0
(320,688 missing values generated)
r; t=0.09 4:42:59

. gen exe_aerobic_advice_m_cr1=exe_aerobic_advice_m if censusregion_sim==1
(403,715 missing values generated)
r; t=0.07 4:42:59

. gen exe_aerobic_advice_m_cr2=exe_aerobic_advice_m if censusregion_sim==2
(438,470 missing values generated)
r; t=0.06 4:42:59

. gen exe_aerobic_advice_m_cr3=exe_aerobic_advice_m if censusregion_sim==3
(440,765 missing values generated)
r; t=0.06 4:42:59

. gen exe_aerobic_advice_m_cr4=exe_aerobic_advice_m if censusregion_sim==4
(439,559 missing values generated)
r; t=0.06 4:42:59

. 
. gen exe_aerobic_advice_f_cr0=exe_aerobic_advice_f if censusregion_sim==0
(272,557 missing values generated)
r; t=0.08 4:42:59

. gen exe_aerobic_advice_f_cr1=exe_aerobic_advice_f if censusregion_sim==1
(393,762 missing values generated)
r; t=0.06 4:42:59

. gen exe_aerobic_advice_f_cr2=exe_aerobic_advice_f if censusregion_sim==2
(438,061 missing values generated)
r; t=1.13 4:43:00

. gen exe_aerobic_advice_f_cr3=exe_aerobic_advice_f if censusregion_sim==3
(440,664 missing values generated)
r; t=0.06 4:43:00

. gen exe_aerobic_advice_f_cr4=exe_aerobic_advice_f if censusregion_sim==4
(438,123 missing values generated)
r; t=0.05 4:43:00

. 
. gen exe_strength_advice_m_cr0=exe_strength_advice_m if censusregion_sim==0
(318,216 missing values generated)
r; t=0.10 4:43:01

. gen exe_strength_advice_m_cr1=exe_strength_advice_m if censusregion_sim==1
(402,937 missing values generated)
r; t=0.07 4:43:01

. gen exe_strength_advice_m_cr2=exe_strength_advice_m if censusregion_sim==2
(438,458 missing values generated)
r; t=0.06 4:43:01

. gen exe_strength_advice_m_cr3=exe_strength_advice_m if censusregion_sim==3
(440,767 missing values generated)
r; t=0.06 4:43:01

. gen exe_strength_advice_m_cr4=exe_strength_advice_m if censusregion_sim==4
(439,535 missing values generated)
r; t=0.06 4:43:01

. 
. gen exe_strength_advice_f_cr0=exe_strength_advice_f if censusregion_sim==0
(267,917 missing values generated)
r; t=0.09 4:43:01

. gen exe_strength_advice_f_cr1=exe_strength_advice_f if censusregion_sim==1
(392,531 missing values generated)
r; t=0.07 4:43:01

. gen exe_strength_advice_f_cr2=exe_strength_advice_f if censusregion_sim==2
(438,021 missing values generated)
r; t=0.06 4:43:01

. gen exe_strength_advice_f_cr3=exe_strength_advice_f if censusregion_sim==3
(440,654 missing values generated)
r; t=0.05 4:43:01

. gen exe_strength_advice_f_cr4=exe_strength_advice_f if censusregion_sim==4
(438,081 missing values generated)
r; t=0.06 4:43:01

. 
. 
. gen exe_active_m_cr0=exe_active_m if censusregion_sim==0
(321,424 missing values generated)
r; t=0.08 4:43:01

. gen exe_active_m_cr1=exe_active_m if censusregion_sim==1
(403,947 missing values generated)
r; t=0.08 4:43:01

. gen exe_active_m_cr2=exe_active_m if censusregion_sim==2
(438,473 missing values generated)
r; t=0.08 4:43:01

. gen exe_active_m_cr3=exe_active_m if censusregion_sim==3
(440,766 missing values generated)
r; t=0.08 4:43:01

. gen exe_active_m_cr4=exe_active_m if censusregion_sim==4
(439,562 missing values generated)
r; t=0.07 4:43:02

. 
. gen exe_active_f_cr0=exe_active_f if censusregion_sim==0
(273,838 missing values generated)
r; t=0.10 4:43:02

. gen exe_active_f_cr1=exe_active_f if censusregion_sim==1
(394,131 missing values generated)
r; t=0.07 4:43:02

. gen exe_active_f_cr2=exe_active_f if censusregion_sim==2
(438,067 missing values generated)
r; t=0.06 4:43:02

. gen exe_active_f_cr3=exe_active_f if censusregion_sim==3
(440,665 missing values generated)
r; t=0.07 4:43:02

. gen exe_active_f_cr4=exe_active_f if censusregion_sim==4
(438,126 missing values generated)
r; t=0.07 4:43:02

. 
. 
. 
. svyset [pweight=svyweight], strata(strata) psu(psu) singleunit(centered)

      pweight: svyweight
          VCE: linearized
  Single unit: centered
     Strata 1: strata
         SU 1: psu
        FPC 1: <zero>
r; t=0.03 4:43:02

. 
. 
. 
. drop if mi(male) //don't want to impute missing values of gender
(0 observations deleted)
r; t=0.10 4:43:02

. 
. gen id=_n //generate unique respondent's ID
r; t=0.03 4:43:02

. 
. 
. compress
  variable srh was float now byte
  variable badphyhlth was float now byte
  variable badmenhlth was float now byte
  variable actpoorhlth was float now byte
  variable asthmadiag was float now byte
  variable cholesteroldiag was float now byte
  variable heartattackdiag was float now byte
  variable heartdiseasediag was float now byte
  variable strokediag was float now byte
  variable diabetesdiag was float now byte
  variable highbloodpressurediag was float now byte
  variable actlim was float now byte
  variable walkdiff was float now byte
  variable dressdiff was float now byte
  variable erranddiffalone was float now byte
  variable funclimit was float now byte
  variable bodycheck was float now byte
  variable bingedrink was float now byte
  variable heavydrink was float now byte
  variable smokeever was float now byte
  variable smoking was float now byte
  variable smokingsim was float now byte
  variable veg1perday was float now byte
  variable greenveg1perday was float now byte
  variable otherveg1perday was float now byte
  variable totalfruit1perday was float now byte
  variable fruitjuice1perday was float now byte
  variable fruit1perday was float now byte
  variable anyflushot was float now byte
  variable seatbeltusage was float now byte
  variable bmicat was float now byte
  variable exercise was float now byte
  variable exercise1type was float now byte
  variable exercise1min was float now int
  variable exercise2type was float now byte
  variable exercise2min was float now int
  variable exe1_intensity was float now byte
  variable exe2_intensity was float now byte
  variable exe_intensity was float now byte
  variable exe_intensity_sim was float now byte
  variable exe_intensity_simplest was float now byte
  variable exe1_min_per_week was float now int
  variable exe2_min_per_week was float now int
  variable exe_vig_min_per_week was float now int
  variable exe_active was float now byte
  variable exe_aerobic_advice was float now byte
  variable exe_strength_advice was float now byte
  variable exe_aero_strength_advice was float now byte
  variable metval1 was float now int
  variable metval2 was float now int
  variable metval_avg was float now int
  variable afforddoc was float now byte
  variable hlthcare was float now byte
  variable hlthcare1864 was float now byte
  variable yearsold was float now byte
  variable agegroup was float now byte
  variable agegroup_sim was float now byte
  variable educ was float now byte
  variable edu was float now byte
  variable employstatus_full was float now byte
  variable employstatus was float now byte
  variable male was float now byte
  variable hispanic was float now byte
  variable prace was float now byte
  variable praceethnicgpf was float now byte
  variable praceethnicgp was float now byte
  variable praceethnicgp_sim was float now byte
  variable mrace was float now byte
  variable mraceethnicgpf was float now byte
  variable mraceethnicgp was float now byte
  variable multiracial_mark was float now byte
  variable praceethnicgp_multi was float now byte
  variable praceethnicgp_multi_sim was float now byte
  variable praceethnicgp_multi_sim2 was float now byte
  variable praceethnicgp_multi_altsim was float now byte
  variable praceethnicgp_multi_simplest was float now byte
  variable hhincome was float now byte
  variable sexualorientation was float now byte
  variable sexualorientation_sim was float now byte
  variable state was float now byte
  variable interview_comp was float now byte
  variable metrogroup was float now byte
  variable censusdivision was float now byte
  variable censusregion was float now byte
  variable censusregion_sim was float now byte
  variable exe_intensity_sim_m was float now byte
  variable exe_intensity_sim_f was float now byte
  variable exe_intensity_simplest_m was float now byte
  variable exe_intensity_simplest_f was float now byte
  variable exe_aerobic_advice_m was float now byte
  variable exe_aerobic_advice_f was float now byte
  variable exe_strength_advice_m was float now byte
  variable exe_strength_advice_f was float now byte
  variable exe_active_m was float now byte
  variable exe_active_f was float now byte
  variable exe_intensity_sim_m1 was float now byte
  variable exe_intensity_sim_m2 was float now byte
  variable exe_intensity_sim_m3 was float now byte
  variable exe_intensity_sim_m4 was float now byte
  variable exe_intensity_sim_m5 was float now byte
  variable exe_intensity_sim_m6 was float now byte
  variable exe_intensity_sim_m7 was float now byte
  variable exe_intensity_sim_m8 was float now byte
  variable exe_intensity_sim_m9 was float now byte
  variable exe_intensity_sim_m10 was float now byte
  variable exe_intensity_sim_m11 was float now byte
  variable exe_intensity_sim_m12 was float now byte
  variable exe_intensity_sim_m13 was float now byte
  variable exe_intensity_sim_m14 was float now byte
  variable exe_intensity_sim_m15 was float now byte
  variable exe_intensity_sim_m16 was float now byte
  variable exe_intensity_sim_m17 was float now byte
  variable exe_intensity_sim_m18 was float now byte
  variable exe_intensity_sim_m19 was float now byte
  variable exe_intensity_sim_m20 was float now byte
  variable exe_intensity_sim_f1 was float now byte
  variable exe_intensity_sim_f2 was float now byte
  variable exe_intensity_sim_f3 was float now byte
  variable exe_intensity_sim_f4 was float now byte
  variable exe_intensity_sim_f5 was float now byte
  variable exe_intensity_sim_f6 was float now byte
  variable exe_intensity_sim_f7 was float now byte
  variable exe_intensity_sim_f8 was float now byte
  variable exe_intensity_sim_f9 was float now byte
  variable exe_intensity_sim_f10 was float now byte
  variable exe_intensity_sim_f11 was float now byte
  variable exe_intensity_sim_f12 was float now byte
  variable exe_intensity_sim_f13 was float now byte
  variable exe_intensity_sim_f14 was float now byte
  variable exe_intensity_sim_f15 was float now byte
  variable exe_intensity_sim_f16 was float now byte
  variable exe_intensity_sim_f17 was float now byte
  variable exe_intensity_sim_f18 was float now byte
  variable exe_intensity_sim_f19 was float now byte
  variable exe_intensity_sim_f20 was float now byte
  variable exe_aerobic_advice_m1 was float now byte
  variable exe_aerobic_advice_m2 was float now byte
  variable exe_aerobic_advice_m3 was float now byte
  variable exe_aerobic_advice_m4 was float now byte
  variable exe_aerobic_advice_m5 was float now byte
  variable exe_aerobic_advice_m6 was float now byte
  variable exe_aerobic_advice_m7 was float now byte
  variable exe_aerobic_advice_m8 was float now byte
  variable exe_aerobic_advice_m9 was float now byte
  variable exe_aerobic_advice_m10 was float now byte
  variable exe_aerobic_advice_m11 was float now byte
  variable exe_aerobic_advice_m12 was float now byte
  variable exe_aerobic_advice_m13 was float now byte
  variable exe_aerobic_advice_m14 was float now byte
  variable exe_aerobic_advice_m15 was float now byte
  variable exe_aerobic_advice_m16 was float now byte
  variable exe_aerobic_advice_m17 was float now byte
  variable exe_aerobic_advice_m18 was float now byte
  variable exe_aerobic_advice_m19 was float now byte
  variable exe_aerobic_advice_m20 was float now byte
  variable exe_aerobic_advice_f1 was float now byte
  variable exe_aerobic_advice_f2 was float now byte
  variable exe_aerobic_advice_f3 was float now byte
  variable exe_aerobic_advice_f4 was float now byte
  variable exe_aerobic_advice_f5 was float now byte
  variable exe_aerobic_advice_f6 was float now byte
  variable exe_aerobic_advice_f7 was float now byte
  variable exe_aerobic_advice_f8 was float now byte
  variable exe_aerobic_advice_f9 was float now byte
  variable exe_aerobic_advice_f10 was float now byte
  variable exe_aerobic_advice_f11 was float now byte
  variable exe_aerobic_advice_f12 was float now byte
  variable exe_aerobic_advice_f13 was float now byte
  variable exe_aerobic_advice_f14 was float now byte
  variable exe_aerobic_advice_f15 was float now byte
  variable exe_aerobic_advice_f16 was float now byte
  variable exe_aerobic_advice_f17 was float now byte
  variable exe_aerobic_advice_f18 was float now byte
  variable exe_aerobic_advice_f19 was float now byte
  variable exe_aerobic_advice_f20 was float now byte
  variable exe_strength_advice_m1 was float now byte
  variable exe_strength_advice_m2 was float now byte
  variable exe_strength_advice_m3 was float now byte
  variable exe_strength_advice_m4 was float now byte
  variable exe_strength_advice_m5 was float now byte
  variable exe_strength_advice_m6 was float now byte
  variable exe_strength_advice_m7 was float now byte
  variable exe_strength_advice_m8 was float now byte
  variable exe_strength_advice_m9 was float now byte
  variable exe_strength_advice_m10 was float now byte
  variable exe_strength_advice_m11 was float now byte
  variable exe_strength_advice_m12 was float now byte
  variable exe_strength_advice_m13 was float now byte
  variable exe_strength_advice_m14 was float now byte
  variable exe_strength_advice_m15 was float now byte
  variable exe_strength_advice_m16 was float now byte
  variable exe_strength_advice_m17 was float now byte
  variable exe_strength_advice_m18 was float now byte
  variable exe_strength_advice_m19 was float now byte
  variable exe_strength_advice_m20 was float now byte
  variable exe_strength_advice_f1 was float now byte
  variable exe_strength_advice_f2 was float now byte
  variable exe_strength_advice_f3 was float now byte
  variable exe_strength_advice_f4 was float now byte
  variable exe_strength_advice_f5 was float now byte
  variable exe_strength_advice_f6 was float now byte
  variable exe_strength_advice_f7 was float now byte
  variable exe_strength_advice_f8 was float now byte
  variable exe_strength_advice_f9 was float now byte
  variable exe_strength_advice_f10 was float now byte
  variable exe_strength_advice_f11 was float now byte
  variable exe_strength_advice_f12 was float now byte
  variable exe_strength_advice_f13 was float now byte
  variable exe_strength_advice_f14 was float now byte
  variable exe_strength_advice_f15 was float now byte
  variable exe_strength_advice_f16 was float now byte
  variable exe_strength_advice_f17 was float now byte
  variable exe_strength_advice_f18 was float now byte
  variable exe_strength_advice_f19 was float now byte
  variable exe_strength_advice_f20 was float now byte
  variable exe_active_m1 was float now byte
  variable exe_active_m2 was float now byte
  variable exe_active_m3 was float now byte
  variable exe_active_m4 was float now byte
  variable exe_active_m5 was float now byte
  variable exe_active_m6 was float now byte
  variable exe_active_m7 was float now byte
  variable exe_active_m8 was float now byte
  variable exe_active_m9 was float now byte
  variable exe_active_m10 was float now byte
  variable exe_active_m11 was float now byte
  variable exe_active_m12 was float now byte
  variable exe_active_m13 was float now byte
  variable exe_active_m14 was float now byte
  variable exe_active_m15 was float now byte
  variable exe_active_m16 was float now byte
  variable exe_active_m17 was float now byte
  variable exe_active_m18 was float now byte
  variable exe_active_m19 was float now byte
  variable exe_active_m20 was float now byte
  variable exe_active_f1 was float now byte
  variable exe_active_f2 was float now byte
  variable exe_active_f3 was float now byte
  variable exe_active_f4 was float now byte
  variable exe_active_f5 was float now byte
  variable exe_active_f6 was float now byte
  variable exe_active_f7 was float now byte
  variable exe_active_f8 was float now byte
  variable exe_active_f9 was float now byte
  variable exe_active_f10 was float now byte
  variable exe_active_f11 was float now byte
  variable exe_active_f12 was float now byte
  variable exe_active_f13 was float now byte
  variable exe_active_f14 was float now byte
  variable exe_active_f15 was float now byte
  variable exe_active_f16 was float now byte
  variable exe_active_f17 was float now byte
  variable exe_active_f18 was float now byte
  variable exe_active_f19 was float now byte
  variable exe_active_f20 was float now byte
  variable exe_intensity_simplest_m1 was float now byte
  variable exe_intensity_simplest_m2 was float now byte
  variable exe_intensity_simplest_m3 was float now byte
  variable exe_intensity_simplest_m4 was float now byte
  variable exe_intensity_simplest_m5 was float now byte
  variable exe_intensity_simplest_m6 was float now byte
  variable exe_intensity_simplest_m7 was float now byte
  variable exe_intensity_simplest_m8 was float now byte
  variable exe_intensity_simplest_m9 was float now byte
  variable exe_intensity_simplest_m10 was float now byte
  variable exe_intensity_simplest_m11 was float now byte
  variable exe_intensity_simplest_m12 was float now byte
  variable exe_intensity_simplest_m13 was float now byte
  variable exe_intensity_simplest_m14 was float now byte
  variable exe_intensity_simplest_m15 was float now byte
  variable exe_intensity_simplest_m16 was float now byte
  variable exe_intensity_simplest_m17 was float now byte
  variable exe_intensity_simplest_m18 was float now byte
  variable exe_intensity_simplest_m19 was float now byte
  variable exe_intensity_simplest_m20 was float now byte
  variable exe_intensity_simplest_f1 was float now byte
  variable exe_intensity_simplest_f2 was float now byte
  variable exe_intensity_simplest_f3 was float now byte
  variable exe_intensity_simplest_f4 was float now byte
  variable exe_intensity_simplest_f5 was float now byte
  variable exe_intensity_simplest_f6 was float now byte
  variable exe_intensity_simplest_f7 was float now byte
  variable exe_intensity_simplest_f8 was float now byte
  variable exe_intensity_simplest_f9 was float now byte
  variable exe_intensity_simplest_f10 was float now byte
  variable exe_intensity_simplest_f11 was float now byte
  variable exe_intensity_simplest_f12 was float now byte
  variable exe_intensity_simplest_f13 was float now byte
  variable exe_intensity_simplest_f14 was float now byte
  variable exe_intensity_simplest_f15 was float now byte
  variable exe_intensity_simplest_f16 was float now byte
  variable exe_intensity_simplest_f17 was float now byte
  variable exe_intensity_simplest_f18 was float now byte
  variable exe_intensity_simplest_f19 was float now byte
  variable exe_intensity_simplest_f20 was float now byte
  variable exe_intensity_sim_m_cr0 was float now byte
  variable exe_intensity_sim_m_cr1 was float now byte
  variable exe_intensity_sim_m_cr2 was float now byte
  variable exe_intensity_sim_m_cr3 was float now byte
  variable exe_intensity_sim_m_cr4 was float now byte
  variable exe_intensity_sim_f_cr0 was float now byte
  variable exe_intensity_sim_f_cr1 was float now byte
  variable exe_intensity_sim_f_cr2 was float now byte
  variable exe_intensity_sim_f_cr3 was float now byte
  variable exe_intensity_sim_f_cr4 was float now byte
  variable exe_intensity_simplest_m_cr0 was float now byte
  variable exe_intensity_simplest_m_cr1 was float now byte
  variable exe_intensity_simplest_m_cr2 was float now byte
  variable exe_intensity_simplest_m_cr3 was float now byte
  variable exe_intensity_simplest_m_cr4 was float now byte
  variable exe_intensity_simplest_f_cr0 was float now byte
  variable exe_intensity_simplest_f_cr1 was float now byte
  variable exe_intensity_simplest_f_cr2 was float now byte
  variable exe_intensity_simplest_f_cr3 was float now byte
  variable exe_intensity_simplest_f_cr4 was float now byte
  variable exe_aerobic_advice_m_cr0 was float now byte
  variable exe_aerobic_advice_m_cr1 was float now byte
  variable exe_aerobic_advice_m_cr2 was float now byte
  variable exe_aerobic_advice_m_cr3 was float now byte
  variable exe_aerobic_advice_m_cr4 was float now byte
  variable exe_aerobic_advice_f_cr0 was float now byte
  variable exe_aerobic_advice_f_cr1 was float now byte
  variable exe_aerobic_advice_f_cr2 was float now byte
  variable exe_aerobic_advice_f_cr3 was float now byte
  variable exe_aerobic_advice_f_cr4 was float now byte
  variable exe_strength_advice_m_cr0 was float now byte
  variable exe_strength_advice_m_cr1 was float now byte
  variable exe_strength_advice_m_cr2 was float now byte
  variable exe_strength_advice_m_cr3 was float now byte
  variable exe_strength_advice_m_cr4 was float now byte
  variable exe_strength_advice_f_cr0 was float now byte
  variable exe_strength_advice_f_cr1 was float now byte
  variable exe_strength_advice_f_cr2 was float now byte
  variable exe_strength_advice_f_cr3 was float now byte
  variable exe_strength_advice_f_cr4 was float now byte
  variable exe_active_m_cr0 was float now byte
  variable exe_active_m_cr1 was float now byte
  variable exe_active_m_cr2 was float now byte
  variable exe_active_m_cr3 was float now byte
  variable exe_active_m_cr4 was float now byte
  variable exe_active_f_cr0 was float now byte
  variable exe_active_f_cr1 was float now byte
  variable exe_active_f_cr2 was float now byte
  variable exe_active_f_cr3 was float now byte
  variable exe_active_f_cr4 was float now byte
  variable _state was double now byte
  variable fmonth was double now byte
  variable dispcode was double now int
  variable seqno was double now long
  variable _psu was double now long
  variable ctelenum was double now byte
  variable pvtresd1 was double now byte
  variable colghous was double now byte
  variable stateres was double now byte
  variable cellfon3 was double now byte
  variable ladult was double now byte
  variable numadult was double now byte
  variable nummen was double now byte
  variable numwomen was double now byte
  variable ctelnum1 was double now byte
  variable cellfon2 was double now byte
  variable cadult was double now byte
  variable pvtresd2 was double now byte
  variable cclghous was double now byte
  variable cstate was double now byte
  variable landline was double now byte
  variable hhadult was double now byte
  variable genhlth was double now byte
  variable physhlth was double now byte
  variable menthlth was double now byte
  variable poorhlth was double now byte
  variable hlthpln1 was double now byte
  variable persdoc2 was double now byte
  variable medcost was double now byte
  variable checkup1 was double now byte
  variable bphigh4 was double now byte
  variable bpmeds was double now byte
  variable bloodcho was double now byte
  variable cholchk was double now byte
  variable toldhi2 was double now byte
  variable cvdinfr4 was double now byte
  variable cvdcrhd4 was double now byte
  variable cvdstrk3 was double now byte
  variable asthma3 was double now byte
  variable asthnow was double now byte
  variable chcscncr was double now byte
  variable chcocncr was double now byte
  variable chccopd1 was double now byte
  variable havarth3 was double now byte
  variable addepev2 was double now byte
  variable chckidny was double now byte
  variable diabete3 was double now byte
  variable diabage2 was double now byte
  variable sex was double now byte
  variable marital was double now byte
  variable educa was double now byte
  variable renthom1 was double now byte
  variable numhhol2 was double now byte
  variable numphon2 was double now byte
  variable cpdemo1 was double now byte
  variable veteran3 was double now byte
  variable employ1 was double now byte
  variable children was double now byte
  variable income2 was double now byte
  variable internet was double now byte
  variable weight2 was double now int
  variable height3 was double now int
  variable pregnant was double now byte
  variable qlactlm2 was double now byte
  variable useequip was double now byte
  variable blind was double now byte
  variable decide was double now byte
  variable diffwalk was double now byte
  variable diffdres was double now byte
  variable diffalon was double now byte
  variable smoke100 was double now byte
  variable smokday2 was double now byte
  variable stopsmk2 was double now byte
  variable lastsmk2 was double now byte
  variable usenow3 was double now byte
  variable alcday5 was double now int
  variable avedrnk2 was double now byte
  variable drnk3ge5 was double now byte
  variable maxdrnks was double now byte
  variable fruitju1 was double now int
  variable fruit1 was double now int
  variable fvbeans was double now int
  variable fvgreen was double now int
  variable fvorang was double now int
  variable vegetab1 was double now int
  variable exerany2 was double now byte
  variable exract11 was double now byte
  variable exeroft1 was double now int
  variable exerhmm1 was double now int
  variable exract21 was double now byte
  variable exeroft2 was double now int
  variable exerhmm2 was double now int
  variable strength was double now int
  variable lmtjoin3 was double now byte
  variable arthdis2 was double now byte
  variable arthsocl was double now byte
  variable joinpain was double now byte
  variable seatbelt was double now byte
  variable flushot6 was double now byte
  variable flshtmy2 was double now long
  variable imfvplac was double now byte
  variable pneuvac3 was double now byte
  variable hivtst6 was double now byte
  variable hivtstd3 was double now long
  variable whrtst10 was double now byte
  variable pdiabtst was double now byte
  variable prediab1 was double now byte
  variable insulin was double now byte
  variable bldsugar was double now int
  variable feetchk2 was double now int
  variable doctdiab was double now byte
  variable chkhemo3 was double now byte
  variable feetchk was double now byte
  variable eyeexam was double now byte
  variable diabeye was double now byte
  variable diabedu was double now byte
  variable painact2 was double now byte
  variable qlmentl2 was double now byte
  variable qlstres2 was double now byte
  variable qlhlth2 was double now byte
  variable caregiv1 was double now byte
  variable crgvrel1 was double now byte
  variable crgvlng1 was double now byte
  variable crgvhrs1 was double now byte
  variable crgvprb1 was double now byte
  variable crgvpers was double now byte
  variable crgvhous was double now byte
  variable crgvmst2 was double now byte
  variable crgvexpt was double now byte
  variable vidfclt2 was double now byte
  variable viredif3 was double now byte
  variable viprfvs2 was double now byte
  variable vinocre2 was double now byte
  variable vieyexm2 was double now byte
  variable viinsur2 was double now byte
  variable victrct4 was double now byte
  variable vigluma2 was double now byte
  variable vimacdg2 was double now byte
  variable cimemlos was double now byte
  variable cdhouse was double now byte
  variable cdassist was double now byte
  variable cdhelp was double now byte
  variable cdsocial was double now byte
  variable cddiscus was double now byte
  variable wtchsalt was double now byte
  variable longwtch was double now int
  variable dradvise was double now byte
  variable asthmage was double now byte
  variable asattack was double now byte
  variable aservist was double now byte
  variable asdrvist was double now byte
  variable asrchkup was double now byte
  variable asactlim was double now int
  variable asymptom was double now byte
  variable asnoslep was double now byte
  variable asthmed3 was double now byte
  variable asinhalr was double now byte
  variable harehab1 was double now byte
  variable strehab1 was double now byte
  variable cvdasprn was double now byte
  variable aspunsaf was double now byte
  variable rlivpain was double now byte
  variable rduchart was double now byte
  variable rducstrk was double now byte
  variable arttoday was double now byte
  variable arthwgt was double now byte
  variable arthexer was double now byte
  variable arthedu was double now byte
  variable tetanus was double now byte
  variable hpvadvc2 was double now byte
  variable hpvadsht was double now byte
  variable shingle2 was double now byte
  variable hadmam was double now byte
  variable howlong was double now byte
  variable hadpap2 was double now byte
  variable lastpap2 was double now byte
  variable hpvtest was double now byte
  variable hplsttst was double now byte
  variable hadhyst2 was double now byte
  variable profexam was double now byte
  variable lengexam was double now byte
  variable bldstool was double now byte
  variable lstblds3 was double now byte
  variable hadsigm3 was double now byte
  variable hadsgco1 was double now byte
  variable lastsig3 was double now byte
  variable pcpsaad2 was double now byte
  variable pcpsadi1 was double now byte
  variable pcpsare1 was double now byte
  variable psatest1 was double now byte
  variable psatime was double now byte
  variable pcpsars1 was double now byte
  variable pcpsade1 was double now byte
  variable scntmny1 was double now byte
  variable scntmel1 was double now byte
  variable scntpaid was double now byte
  variable scntwrk1 was double now byte
  variable scntlpad was double now byte
  variable scntlwk1 was double now byte
  variable sxorient was double now byte
  variable trnsgndr was double now byte
  variable rcsgendr was double now byte
  variable rcsrltn2 was double now byte
  variable casthdx2 was double now byte
  variable casthno2 was double now byte
  variable emtsuprt was double now byte
  variable lsatisfy was double now byte
  variable adpleasr was double now byte
  variable addown was double now byte
  variable adsleep was double now byte
  variable adenergy was double now byte
  variable adeat1 was double now byte
  variable adfail was double now byte
  variable adthink was double now byte
  variable admove was double now byte
  variable mistmnt was double now byte
  variable adanxev was double now byte
  variable qstver was double now byte
  variable qstlang was double now byte
  variable mscode was double now byte
  variable _ststr was double now long
  variable _chispnc was double now byte
  variable _crace1 was double now byte
  variable _cprace was double now byte
  variable _dualuse was double now byte
  variable _rfhlth was double now byte
  variable _hcvu651 was double now byte
  variable _rfhype5 was double now byte
  variable _cholchk was double now byte
  variable _rfchol was double now byte
  variable _michd was double now byte
  variable _ltasth1 was double now byte
  variable _casthm1 was double now byte
  variable _asthms1 was double now byte
  variable _drdxar1 was double now byte
  variable _prace1 was double now byte
  variable _mrace1 was double now byte
  variable _hispanc was double now byte
  variable _race was double now byte
  variable _raceg21 was double now byte
  variable _racegr3 was double now byte
  variable _race_g1 was double now byte
  variable _ageg5yr was double now byte
  variable _age65yr was double now byte
  variable _age80 was double now byte
  variable _age_g was double now byte
  variable htin4 was double now byte
  variable htm4 was double now int
  variable wtkg3 was double now int
  variable _bmi5 was double now int
  variable _bmi5cat was double now byte
  variable _rfbmi5 was double now byte
  variable _chldcnt was double now byte
  variable _educag was double now byte
  variable _incomg was double now byte
  variable _smoker3 was double now byte
  variable _rfsmok3 was double now byte
  variable drnkany5 was double now byte
  variable drocdy3_ was double now int
  variable _rfbing5 was double now byte
  variable _drnkwek was double now long
  variable _rfdrhv5 was double now byte
  variable ftjuda1_ was double now int
  variable frutda1_ was double now int
  variable beanday_ was double now int
  variable grenday_ was double now int
  variable orngday_ was double now int
  variable vegeda1_ was double now int
  variable _misfrtn was double now byte
  variable _misvegn was double now byte
  variable _frtresp was double now byte
  variable _vegresp was double now byte
  variable _frutsum was double now int
  variable _vegesum was double now int
  variable _frtlt1 was double now byte
  variable _veglt1 was double now byte
  variable _frt16 was double now byte
  variable _veg23 was double now byte
  variable _fruitex was double now byte
  variable _vegetex was double now byte
  variable _totinda was double now byte
  variable metvl11_ was double now int
  variable metvl21_ was double now int
  variable actin11_ was double now byte
  variable actin21_ was double now byte
  variable padur1_ was double now int
  variable padur2_ was double now int
  variable _minac11 was double now long
  variable _minac21 was double now long
  variable pamiss1_ was double now byte
  variable pamin11_ was double now long
  variable pamin21_ was double now long
  variable pa1min_ was double now long
  variable pavig11_ was double now int
  variable pavig21_ was double now int
  variable pa1vigm_ was double now int
  variable _pacat1 was double now byte
  variable _paindx1 was double now byte
  variable _pa150r2 was double now byte
  variable _pa300r2 was double now byte
  variable _pa30021 was double now byte
  variable _pastrng was double now byte
  variable _parec1 was double now byte
  variable _pastae1 was double now byte
  variable _lmtact1 was double now byte
  variable _lmtwrk1 was double now byte
  variable _lmtscl1 was double now byte
  variable _rfseat2 was double now byte
  variable _rfseat3 was double now byte
  variable _flshot6 was double now byte
  variable _pneumo2 was double now byte
  variable _aidtst3 was double now byte
  variable psu was double now long
  (1,387,937,664 bytes saved)
r; t=373.71 4:49:16

. 
. 
. save "Data Ready for Analysis/brfss2015-readyforanalysis.dta",replace
file Data Ready for Analysis/brfss2015-readyforanalysis.dta saved
r; t=0.62 4:49:16

. 
. 
. 
. *Ouput data for multiple imputation
. drop if state==72 //delete Puerto Rico
(5,405 observations deleted)
r; t=0.42 4:49:17

. 
. keep id svyweight strata psu /// technical variables
> exercise exercise1type exercise1freq exercise1min exercise2type exercise2freq 
> exercise2min muscleexercise exe1_intensity exe2_intensity exe_intensity_simple
> st exe_aerobic_advice exe_strength_advice exe_active /// physical activities
> state yearsold male educ hhincome praceethnicgp_multi_sim ///
> srh badphyhlth badmenhlth bmicat employstatus_full //auxiliary variables
r; t=0.16 4:49:17

. 
. save "Data Ready for Analysis/brfss2015-readyforimpute.dta",replace
file Data Ready for Analysis/brfss2015-readyforimpute.dta saved
r; t=0.13 4:49:17

. 
. 
. 
. *Ouput data for listwise analysis
. use "Data Ready for Analysis/brfss2015-readyforanalysis.dta",clear
r; t=0.38 4:49:18

. 
. keep svyweight strata psu /// technical variables
> exe_aerobic_advice_m* exe_strength_advice_m* exe_aerobic_advice_f* exe_strengt
> h_advice_f* state yearsold year praceethnicgp_multi_sim male educ hhincome exe
> _aerobic_advice_m_cr* exe_strength_advice_m_cr* exe_aerobic_advice_f_cr* exe_s
> trength_advice_f_cr*
r; t=0.16 4:49:18

. save "Data Ready for Analysis/brfss2015-readyforlistwiseanalysis.dta",replace
file Data Ready for Analysis/brfss2015-readyforlistwiseanalysis.dta saved
r; t=0.19 4:49:18

. 
. 
. 
. *save `pgm'.dta,replace
. 
. *estwrite * using `pgm',replace
. 
. 
. log close
      name:  <unnamed>
       log:  C:\Users\Yanan and Ben\Desktop\NHPI-exercise Replication Package\20
> 250822-brfss2015-dataprep.log
  log type:  text
 closed on:  25 Aug 2025, 04:49:18
--------------------------------------------------------------------------------
